Event Based Scheduling for Direct Query Mode

[Ram_DCT]

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.

[nickyvv]

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

[Ram_DCT]

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

[v-easonf-msft]

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-Kons...

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

Best Regards,
Community Support Team _ Eason