Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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...
Need Help
  • v-juanli-msft's avatar
    v-juanli-msft
    6 years ago

    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
    Maggie
    Community 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.

     

     

     

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Could you please share the API setup setps . Its really helpfull to me. 

 

 

v-juanli-msft's avatar
v-juanli-msft
Community Support
6 years ago

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
Maggie
Community 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.

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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. 

  • bdavison's avatar
    bdavison
    Regular Visitor
    5 years ago

    Hi v-juanli-msft (or anyone else who can help)

    The above seems to work fine, but i'm having an issue with the Authorization token.  

    I'd like this to work each time the dataset is refreshed, but after setting this up the Authorization token is only valid for 1 hour.  

    It expires after an hour and i've seen that you need to update the 

    The solution seems to be setting up the initial call to 

    https://login.microsoftonline.com/[tenant_id]/oauth2/token/ to get a refresh token.  

     

    which is then used.  can you provide any guidance on setting up the refresh token needed here