Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Helper II
Helper II

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

Community Champion
Community Champion

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

Did I answer your question? Mark my post as a solution!

Blog: | @NickyvV

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





Hi , @Ram_DCT 

I don't have much experience in this.

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


Best Regards,
Community Support Team _ Eason

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.