Forum Discussion
Power BI Report based on the dataset refresh data
Hello ,
I am trying to create a power BI dashboard where I can show all existing prod dataset refresh status to higher management. For that I am using Microsoft flow to bring the dataset refresh history on timely .
Now here I am able to create a Microsoft flow to bring the refresh history data but not able to save the flow job result which in to excel file .
Any one created the dataset refresh status dashboard on power BI. If yes kindly advise me.
Hi Anonymous
In this link,
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getrefreshhistoryingroup
click on the "try it", on the right window, provide the "group id"(workspace id), datatset id, click "run",
then copy the url (after "Get") in the "Url" box in Power BI (Get daata->Web connector->Advanced)
copy the code (after "Authorization") in the box in Power BI as i lined.
Then select the correct credential in the pop-out window to connect to the data source,
if all above are successful, then in edit queries, click on the "list"->"convert it to table"-"expand"
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
5 Replies
Hi Anonymous
You can find a link to display the refresh history in the dataset settings. You can also retrieve the refresh history programmatically by using the Power BI REST API. By using a custom solution, you can monitor the refresh history of multiple datasets in a centralized way.
https://docs.microsoft.com/en-us/power-bi/refresh-data#configure-scheduled-refresh
Best Regards
Maggie
Community Support Team _ Maggie Li
Hi Anonymous
In this link,
https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getrefreshhistoryingroup
click on the "try it", on the right window, provide the "group id"(workspace id), datatset id, click "run",
then copy the url (after "Get") in the "Url" box in Power BI (Get daata->Web connector->Advanced)
copy the code (after "Authorization") in the box in Power BI as i lined.
Then select the correct credential in the pop-out window to connect to the data source,
if all above are successful, then in edit queries, click on the "list"->"convert it to table"-"expand"
Best Regards
MaggieCommunity Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.