Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi All,
Does anyone know if it is possible to have a Power BI report/dataset have some sort of alert or notification if a source data set is not refresh by the time a schedule Power BI dataset is to start.? Here's my scenario below:
The majority of my reports are linked to our Azure SQL server or what we call our Azure Datawarehouse that refreshes nightly that normally takes 45 min to an hour to complete but can sometimes encounter network issues and fail or take longer. My dilema is that I have some Power BI reports on scheduled refreshes with subscription snapshots that refresh no matter what and then send out a subscription email, even if the source data fails. Is there a way for the Power BI to be alerted or something to set up so when these source data sets fail so the Power BI datasets don't auto refresh on schedule and send duplicated stale data snapshots for 2 days prior? I've been trying to work with my IT team and they suggested Power Shell but I don't know much about that or how it would work.
Thanks!
Solved! Go to Solution.
yes, you can stop the scheduled refresh and use Powershell or Power Automate to create a process that polls your data source for completion of the source refresh, and then issue an REST API request to refresh the dataset. That is a much better use of your capacity resources than a schedule.
Here is the sandbox where you can try it out
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/refreshdatasetingroup
You can specify the same notification options so that you receive an email on failure.
yes, you can stop the scheduled refresh and use Powershell or Power Automate to create a process that polls your data source for completion of the source refresh, and then issue an REST API request to refresh the dataset. That is a much better use of your capacity resources than a schedule.
Here is the sandbox where you can try it out
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/refreshdatasetingroup
You can specify the same notification options so that you receive an email on failure.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
19 | |
18 | |
9 |