topic Re: Event Based Scheduling for Direct Query Mode in Service

Event Based Scheduling for Direct Query Mode

Ram_DCT — Wed, 26 Aug 2020 11:56:45 GMT

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 Sybase ASE DB and I am using stored procedures to get data into Power BI Desktop.

What I need is to refresh the dataset in Power BI Services based on the event. Now, what is that event is going to be - For example, refresh should be triggered only when my Sybase DB has been updated fully. Also, we need to have an email notification when data refresh is not successfully executed.

Re: Event Based Scheduling for Direct Query Mode

nickyvv — Tue, 25 Aug 2020 10:18:40 GMT

Hi 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).

Re: Event Based Scheduling for Direct Query Mode

Ram_DCT — Tue, 25 Aug 2020 12:05:49 GMT

Great! 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

Re: Event Based Scheduling for Direct Query Mode

v-easonf-msft — Thu, 27 Aug 2020 03:01:29 GMT

Hi , Ram_DCT

I don't have much experience in this.

I find some documents, please check if they are useful .

https://community.powerbi.com/t5/Community-Blog/Refresh-Power-BI-dataset-with-Microsoft-Flow-by-Konstantinos/ba-p/622941

https://powerbi.microsoft.com/en-us/blog/announcing-data-refresh-apis-in-the-power-bi-service/

Best Regards,
Community Support Team _ Eason