Power BI dataset info report

[Anonymous]

Hello, 

I would like to create a new power bi report where I can see all of the power bi datasets refresh info.

Currently we have more then 20 different power bi reports. Now its very hard to check the dataset execution information checking manually . So here I would like to create a new power BI report which shows the all of power bi dataset refresh start time and end time . ect.

Please suggest If you any one crated this kind report .

[Jayendran]

Hi @Anonymous ,

Basically you have to call the Get Refresh History In Group API to get the details and create your PBI Report from it.

GET https://api.powerbi.com/v1.0/myorg/groups/{groupId}/datasets/{datasetId}/refreshes

I've done the same thing for Gateways Management, and published the article 

https://community.powerbi.com/t5/Community-Blog/Power-BI-Gateway-Monitoring-amp-Administrating-Part-1/ba-p/750509

https://community.powerbi.com/t5/Community-Blog/Power-BI-Gateway-Monitoring-amp-Administrating-Part-2/ba-p/750765

[Anonymous]

Thanks, 

Most of my datasets get refersh after dataload . Here we are using Airflow job.. How can i capture this jobs info on power bi report as well. 

Any thoughts. 

[Jayendran]

Hi @Anonymous ,

I'm not an expert in Airflow, but as a developer I'd suggest always try to use the API's. 

It seems Airflow is also providing some api to get the history. So using that you can achieve this.

https://stackoverflow.com/questions/53849144/airflow-rest-api-how-to-get-the-history-of-executed-tasks

If my replay helps please mark it as Answer/Give Kudos, so that it will help others too

[Anonymous]

Any inputs here please.. 

Other way  I would like to just create a reports where I can see all of the datasets refresh history .