Forum Discussion
Ram_DCT
Helper II
Helper IIEvent Based Scheduling for Direct Query Mode
Hi Team, I am using power BI desktop to publish my dataset to the services and later I am going to use those datasets for my paginated report in PBI Report Builder. Please note that my source is ...
nickyvv
Most Valuable Professional
Most Valuable ProfessionalHi Ram_DCT,
Unfortunately this is not something that is supported out-of-the-box in the Power BI Service. Scheduling there can only be time-based.
If you'd like to do it event-based you would have to use PowerShell to call the Power BI cmdlets (or the REST API itself) to refresh the dataset.
You can also use Power Automate to do a refresh based on a trigger (updated Sybase DB).
Unfortunately this is not something that is supported out-of-the-box in the Power BI Service. Scheduling there can only be time-based.
If you'd like to do it event-based you would have to use PowerShell to call the Power BI cmdlets (or the REST API itself) to refresh the dataset.
You can also use Power Automate to do a refresh based on a trigger (updated Sybase DB).
Ram_DCTHelper II
Helper IIGreat! Appreciate your help here.
Unfortunately, even we do not have any integration experience in doing this out-of-box activity.
It would be very helpful if you can share some documents or steps around integrating the stated approach [i.e. Power Shell, Rest APIs, etc.].
Thanks,
Ram
- v-easonf-msft
Community Support
Hi , Ram_DCT
I don't have much experience in this.
I find some documents, please check if they are useful .
https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/
Best Regards,
Community Support Team _ Eason
