It’s been a while since I wanted to try using Power BI for something practical. And this is not to say there are no practical applications for Power BI It’s all about me being a Power Platform consultant who is working primarily with model-driven applications, and, every now and then, with Power Automate and Canvas… Read More »
Business process flows can definitely help guide our application users – they always look nice in the demos, and they easily draw positive feedback. But, it seems, when the BPF is designed to cover multiple entities, there are some quirks there. Here is the BPF I wanted to create: There are two entities involved: Main… Read More »
This is definitely not something new – you’ll find quite a few blog posts on this topic. But if, for some reason, you are not aware of this feature, it might make your day. As it made mine a few months back… and the only reason I’m talking about it now is that, well, it’s… Read More »
In the previous post, I wrote about how we can use Dataverse image columns in the Power BI Paginated reports (or in the SSRS reports for that matter). What kept bugging me is whether we could actually use a Power Apps Portal to surface that image. Turned out that is not doable, at least not… Read More »
With the image columns in Dataverse, we can easily add fields to store images directly in the tables like this: This is great, since this makes all those images/documents much easier to identify than if they are stored in Sharepoint. In terms of storage, those images are stored in the file storage which is cheaper… Read More »
There is a SQL Connector in Power Automate, and it has couple of triggers which are dependent on the IDENTITY/ROWVERSION columns in SQL: The existence of those two columns in the table is a pre-requisite for the trigger to work: https://docs.microsoft.com/en-us/connectors/sql/#when-an-item-is-created-(v2) There is a catch there, though, and I probably would not know about it… Read More »
I’ve been trying to promote my technology blog through LinkedIn for as long as it’s been out there, and all has been going pretty well. Google analytics audience overview for the last 3 years would please any stock trader if this were a stock chart: Well, at this rate my blog might be following in… Read More »
“Common Data Service” connectors don’t have an “Upsert” action: And it would have been a problem for one of the flows I had to implement recently if not for David Yack who pointed out that Update action will do an Upsert. What?? Well, he was absolutely right, here you go: Have fun folks. And thank… Read More »
It’s been a while since I wrote about SSIS – most of what we do these days is happening in the cloud. But, sometimes, we still need to resort to the old good time-proven technologies… such as SSIS. What’s the de-facto standard toolset of any Dynamics/PowerPlatform consultant who need to use SSIS? Well, that’s, of… Read More »
Just a few days ago, when I was writing a post about Power BI Paginated Reports, “Dataverse” connection type was still called “Common Data Service(Preview)” there. As of today, in the updated version of the Power BI Report Builder, it’s called “Dataverse”: There is no reference to the preview anymore, but, apparently, it’s still a… Read More »