Microsoft Power BI Insights: Dataset refresh; Power BI Pixel; Complicated pages; Aggregations; KPIs; Pro users

Microsoft Power BI pros delved into dataset refresh, Power BI Pixel, pulling data from complicated pages, the case for aggregations and more.

Scheduling dataset refresh

Chris Webb was intrigued when Microsoft premiered the refresh dataset action for Power Automate in 2019. Power BI's own built-in scheduled refresh functionality is limited, with little flexible to set different schedules for weekends, weekdays and holidays and few controls on parallel refresh operations. To test out a better scheduling approach, Webb created a calendar in Outlook tracking Power BI refreshes, setting appointments for every refresh. In the title of each, he logged the unique identifier for the dataset. He wrote:

This isn’t something I recommend putting into production but I think it’s very interesting as a proof-of-concept. I guess Logic Apps would be a more robust alternative than Power Automate and I would want to be 100% sure that events fired when I was expecting them to fire, so some thorough testing would be needed.

Webb noted that when a refresh operation is triggered, Power BI needs to line up the required resources and in Shared capacity, it can take a few minutes for things to get started.

Using Power BI Pixel

FREE Membership Required to View Full Content:

Joining MSDynamicsWorld.com gives you free, unlimited access to news, analysis, white papers, case studies, product brochures, and more. You can also receive periodic email newsletters with the latest relevant articles and content updates.
Learn more about us here

Get full access

or login