Conditional Dataset Refresh

[Anonymous]

I have developed several reports that in the next days will be uploaded to PowerBI cloud.

My question is:

How can I refresh the datasets only when the data feeding proccess of the database (E.T.L.) has finished.

Is there a way to access a table (through the Schedule Refresh dialog) whereas that info is located and if the value of a certain field is 'Success' then refresh else try again in one hour?

If the above logic is not available, is there any workaround? 

Thank you.

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

According to your logic, perhaps integrating the rest API with shell scripts or Python scripts can solve this problem.

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

What connection mode do you use to connect to the data source? If ETL is completed at the same time every day, you can directly set the corresponding schedule refresh time. If the direct query connection is used, the data is always up-to-date, but the last cache is shown. Refresh the cache or trigger the calculation to refresh the dataset.

If you have a modified DateTime (or updated DateTime) in your table, then the process of incremental refresh can monitor that field, and only get rows that their date/time is after the latest date/time in that field in the previous refresh. To enable this process, you can enable the Detect Data Changes, and then choose the modified date or update date from the table.

https://docs.microsoft.com/en-us/power-bi/admin/service-premium-incremental-refresh 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.