Forum Discussion
Helper IIIHow to Monitoring PowerBI dataset refresh
Hi Sylvain74,
I am not aware of any such functionality. But I think you could make use of the Power BI APIs, to be specific the refresh APIs which upon invoking, will return a JSON response with details about the success/failure of the last refresh.
There are several Python libraries that you could use to write a simple Python script that calls the API and checks the refresh status of each data set. If you have a computer that is always on, then you could create a scheduled task using Windows task scheduler and schedule the python script to run at a predefined frequency and subsequently process the returned JSON responses and store the processed responses in a database table (for example SQL Server) programmatically. You could further use this table in a Power BI dashboard to monitor the refresh status of all the datasets.
I never had any such requirements and therefore I have never searched for any such functionality.
This is something I could think of and ideally, this approach should work.
Hi Sylvain74,
I am not aware of any such functionality. But I think you could make use of the Power BI APIs, to be specific the refresh APIs which upon invoking, will return a JSON response with details about the success/failure of the last refresh.
There are several Python libraries that you could use to write a simple Python script that calls the API and checks the refresh status of each data set. If you have a computer that is always on, then you could create a scheduled task using Windows task scheduler and schedule the python script to run at a predefined frequency and subsequently process the returned JSON responses and store the processed responses in a database table (for example SQL Server) programmatically. You could further use this table in a Power BI dashboard to monitor the refresh status of all the datasets.
I never had any such requirements and therefore I have never searched for any such functionality.
This is something I could think of and ideally, this approach should work.