Skip to main content
cancel
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

Reply
Ram_DCT
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.

3 REPLIES 3
nickyvv
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.com | @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.].

Thanks,

Ram

 

 

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

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors