Forum Discussion
Refresh Power BI Dataset using Power Automate
- 1 year ago
Oh sorry. I forget that the power automate doesn't have all the requests from power bi rest api. You could do two things:
- Run an http request to power bi rest api to get that info like this link: https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/get-refresh-history-in-group
- The alternative would be creating a table inside the dataset that has the datetime of the refresh. A table that has only one column and one value. Something like DateTime.LocalNow(). Once that's in the model. At Automate Create a variable with the datetime before running the refresh. After running the refresh, you can "Run a query against a dataset". Use DAX to get the value of that table of one row and one column. If the date is after the refresh was run, then it has finnished successfully. You might need a break by time know how long the refresh usually last because if it fails, the condition of checking if the date is older than the one in the query will never match.
I hope that helps
Hi mp390988 ,
Thanks for reaching out to the Microsoft fabric community forum.
Thanks for your prompt response
In addition to ibarrau , and MohamedFowzan1 , I have added the previously solved threads and learning documents, which can be helpful in understanding and resolving the issue.
Solved: Dataset Refresh Failure Notification Through Dataf... - Microsoft Fabric Community
Solved: Flow to refresh dataflow and dataset in PowerBI Issue
Power BI dataset Refresh failure notification when... - Microsoft Fabric Community
Datasets - Get Refresh History - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Best Regards,
Lakshmi
Hi mp390988 ,
We haven’t heard back from you regarding our last response, so I just wanted to check in to see if you were able to resolve the issue. If you have any further questions or need assistance, please feel free to let us know.
Best Regards,
Lakshmi
- v-lgarikapat1 year agoCommunity Support
Hi mp390988 ,
We haven’t heard back from you regarding our last response, so I just wanted to check in to see if you were able to resolve the issue. If you have any further questions or need assistance, please feel free to let us know.
Best Regards,
Lakshmi
- v-lgarikapat11 months agoCommunity Support
Hi mp390988 ,
We haven’t heard back from you regarding our last response, so I just wanted to check in to see if you were able to resolve the issue. If you have any further questions or need assistance, please feel free to let us know.
Best Regards,
Lakshmi