cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
admiralman Member
Member

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

Accepted Solutions
Highlighted
zoloturu
Advisor

Re: Conditional Dataset refresh

@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
Advisor

Re: Conditional Dataset refresh

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

admiralman Member
Member

Re: Conditional Dataset refresh

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

Highlighted
zoloturu
Advisor

Re: Conditional Dataset refresh

@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

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 307 members 3,591 guests