Forum Discussion
Power BI Report based on the dataset refresh data
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.
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"
Maggie
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your solution .. its worked for me..
How to manage the relationship if i would like to pull multiple dataset history .
Would like to show Overall success percentage for all the reports.