Get refresh time and status from Power BI Service into Desktop

[trungnguyen]

Hi guys,

I would like to create a report to show the refresh time and status of each dataset and dataflow of all workspace.

It'll allow to do a check in an only report instead of going to each workspace.

I have found a post showing how to do it with PowerShell and rest API of Power BI Service but the inconvient is that the data is stored in a csv local file so I'll have to launch it everyday or automate it 

Thank you in advance !

[amitchandak]

@trungnguyen , get the REST API Data directly into power bi and then you should be able to refresh

https://community.powerbi.com/t5/Power-Query/Using-a-REST-API-as-a-data-source/td-p/50400
https://www.progress.com/tutorials/odbc/directquery-your-custom-rest-api-in-power-bi

[trungnguyen]

Why I I should be able to refresh ? I'm not looking for refresh ...