Tabel visula in a repots with Dataset Refresh times

[amaleranda]

Hi Guru, 

I need a tabel like below for my published datasets in the servcies

DatasetName             DateLastRefreshed              Status           Comments

Dataset1                     08/4/2020 8:11:27PM         Completed    

Dataset2                      11/4/2020 10:20:35AM     Failed             your data gateway is offline or couldn't*

I need this to be a tabel repot in desktop, then I can publish this report in to servcie so users can see it.

your help is much appriciated.

Regards

Amal Eranda

[Greg_Deckler · Accepted solution]

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getrefreshhistory

[Greg_Deckler]

Hmm, that's interesting, I do not know where to get that information from but I am going to check into it.

[amaleranda]

Greg.. Thanks superstar

[Greg_Deckler]

🙂

[amaleranda]

@Greg_Deckler 

idea is to extract below information from the services to a tabel. below is refresh history of only one dataset. To access the latest we can get max end time of each dataset refresh. The challange is how do I get accces to below information for each dataset published in the services.

[v-chuncz-msft · Accepted solution]

@amaleranda 

By the way, you may leave a comment on this idea.

[Greg_Deckler · Accepted solution]

https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/getrefreshhistory