Last year I was working on a requirement, to implement event-based dataset refresh that can send out an email when the refresh has completed successfully or failed. I came across Power Automate as the tool of choice to achieve this task easily and efficiently. Power Automate becoming main stream into Power BI visual does speak […]
Event-based Power BI dataset refresh with email notification Read More »
In this blog post, I will be showing the Power BI web service settings for implementing Power BI REST API using Service Principal and Sample Powershell script. This is a continuation of previous blog post “Power BI REST API using Service Principal – Part 1“. Power BI web portal settings In order to perform these
Power BI REST API using Service Principal – Part 2 Read More »
This blog post is related to one of the issues that I came across while working with Power BI REST API using Service principal (Certificate type) authentication. I had posted my question on Stackoverflow here and even raised a ticket with Microsoft. In the end, with the help of MS product team, I was finally able to unlock the issue
Power BI REST API using Service Principal – Part 1 Read More »
Sometime back I was working on a requirement to extract millions of records from a datawarehouse system for Power BI reporting. I was using native SQL query with multiple table joins and where clauses. As the records were in millions, implementing incremental refresh was the best choice to avoid reloading the entire data on every
Why my Power BI Incremental refresh isn’t working? (Hint: Native SQL Query) Read More »
This is my first post on DataUnlock. It is my initiative to unlock the data value by sharing ideas related to the data technology. Who am I? My name is Sujit Kadam. I am Senior Consultant – Microsoft Data and Analytics at Revenite, Melbourne, Australia. I have done my Bachelor of Engineering from University of
