Anyone know how we can find out on a daily basis the status of all our refreshes and which reports they're affecting. After using PBI + premium for a few years, we often find out that refreshes arent working. Individuals who setup the refreshes are being notified, but they're not always around .
Solved! Go to Solution.
We've used this on ther blog posts to now create a MS flow, that queries our whole PBI setup using these APIs, (groups, then datasets) get the very last refresh status and for any that are NOT completed, populates a SQL table with the detail. Then have a seperate PBI dashboard lookin at this data for the DW team to then action.. we think its pretty cool
Would love to share, but not sure how ?