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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
admiralman
Advocate II
Advocate II

Conditional Dataset refresh

I'm wondering if there is a way to conditionally update a dataset. I am connecting to SQL Server and populating 4 tables in my dataset from 4 source tables. I would like to only update my dataset if the run date in the source is in the same month as the current month. 

1 ACCEPTED SOLUTION

@admiralman,

 

Few advises about REST API.

 

1) You need to have Power BI Pro license.

2) Then register an application (even fake one). See details - https://docs.microsoft.com/en-us/power-bi/developer/register-app

3) Then create a code for authorization token generation - https://docs.microsoft.com/en-us/power-bi/developer/get-azuread-access-token

 

Regards,

Ruslan

View solution in original post

3 REPLIES 3
zoloturu
Memorable Member
Memorable Member

Hi @admiralman,

 

It is not easy to use. But I can tell you some approaches:

 

1. Purchase Power BI Premium capacity. Then follow the instructions below you will be able to have only fresh data - https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

 

2. Another option is to make some code in C#, Javascript or R. In details you would need to retrieve date from a database and compare it to current month programmatically. And assign some schedule to that. Then you can call REST API request to Power BI dataset to refresh it if a date is new. Refer to the link - https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/refreshdatasetingroup

 

Regards,

Ruslan

Gotcha...since we dont have the need for premium I will look at the REST call to refresh data. Thanks.

@admiralman,

 

Few advises about REST API.

 

1) You need to have Power BI Pro license.

2) Then register an application (even fake one). See details - https://docs.microsoft.com/en-us/power-bi/developer/register-app

3) Then create a code for authorization token generation - https://docs.microsoft.com/en-us/power-bi/developer/get-azuread-access-token

 

Regards,

Ruslan

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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

Top Solution Authors
Top Kudoed Authors