Lately, I published the first out of two blogs about monitoring your on-premises data gateway. The first blog was all about monitoring your gateway up time but doesn't tell you when one of the connections on your gateway is down. This blog will go in more detail how you can monitor your data source connectivity …
Power BI includes a very rich set of data connectors to get your data from. Both connectors to on-premises and cloud solutions are provided which sometimes require an On-premises data gateway in order to refresh your dataset in the Power BI service. This additional component, does not have out-of-the box monitoring functionality. But why not …
As a Data & Analytics consultant, working on tons of different projects, it is very likely that I'm the creator and owner of a whole lot of dataflow and dataset refreshes. Since these refreshes can only be managed by the owner, this limits the rest of my colleagues from updating the scheduled and maintaining the …
Continue reading Manage all your Power BI refreshes in one place with Power Automate (Flow)
As Power BI enthusiasts and consultants, we are building tons of reports. All with the goal to enable the business to take data driven decisions by providing them with the right information at the right time. Though, if your reporting audience is growing, there is no way to satisfy all your users. Of course, the …
Over a year ago, I wrote a blog about Multiple tier architecture and continuous delivery with Power BI, mainly an overview of the setup and manually creating development and production content. This blog will continue this story in more detail of Power BI CI/CD with Azure DevOps automated deployments. A solution where Dave Ruijter, Ton …
Continue reading Versioning and CI/CD for Power BI with Azure DevOps
Dataflows are part of the Power BI service for a while now. More and more people are starting to benefit from it in multiple perspectives. The two most heard ones are re-use of data (and logic), but also isolate refreshes to avoid dependencies of refresh failures from different sources.Same as for your data sources, you …
Continue reading Move dataflows across workspaces with the Power BI REST API
Last week, on Friday Septembre 13th, I presented at Data:Scotland. As the name already suggests, in Scotland, Glasgow to be precise. An awesome community event with loads of intresting people and reality well organized. Definitely one to put on your list to visit once! At this event, I presented my all new session about "AI …
Continue reading Data:Scotland – Make AI available for everyone!
It has been a month since my last blog. Busy times with a lot of interesting projects, so less time for writing blogs. Last weekend I was traveling to Power Saturday in Paris. So now I finally had some time to write the blog I was thinking about for a while. Dataflows! Power BI dataflows …
Continue reading Inform your end-users by embedding dataflow refresh times in your Power BI reports
Last week, I was challenged by moving my Power BI dataset through the next stage in my DTAP pipeline. I simply wanted to re-assign my connections to the data source in the next stage. In my case, I created a separate workspace including separate dataflows for each stage. Since de dataflows connector in Power BI is …
In some cases, you might want to split your report and data model into separate Power BI Desktop files. For example, to work in together on the same content or create multiple reports based on the same dataset. There can be many reasons to do this. But once you started building everything one file, you …
