cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
chrischiappazzo Regular Visitor
Regular Visitor

Incremental Refresh - Something Went Wrong

I am struggling to set up incremental refresh for my data set.

I have used the various resources available offered by the forum/powerbi service but cant get it to work for my data set (to link a few)

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

https://powerbi.microsoft.com/en-us/blog/incremental-refresh-in-power-bi-premium/

https://community.powerbi.com/t5/Community-Blog/Important-Considerations-for-Setting-up-Incremental-...

 

Anyway, back to how i am approaching the problem.

In query editor, on my data tab I have gone onto manage parameters.

I have created 2 new parameters.

RangeStart: 01/03/19 (starting date of my data)

RangeEnd 01/01/2025 (end date as a random future date so i don't filter out any new data that comes in)

 

Then on my data set on my date/time column i have custom filtered the column between RangeStart-RangeEnd.

 

When i try apply the query i get a pop up message

"Something went wrong" - Object reference not set to an instance of an object. And it won't apply the changes, hence can't then set up the incremental refresh capability.

 

Can someone offer any suggestions. Does my RangeEnd date need to be to the last date of raw data in the model, however if i do this, and filter by RangeEnd, how does any new data past the RangeEnd date (ie today 20/05/19) get refreshed in the model?

 

Cheers.

 

2 REPLIES 2
chrischiappazzo Regular Visitor
Regular Visitor

Re: Incremental Refresh - Something Went Wrong

After a lot of fiddling, it is now letting my apply the query, but when i go into incremental refresh for the particular query it comes up with

"Unable to confirm if the M query can be folded. It is not recommended to use incremental refresh with non-foldable queries"

 

How to fix this?

Microsoft v-yulgu-msft
Microsoft

Re: Incremental Refresh - Something Went Wrong

Hi @chrischiappazzo ,

 

From this documentit's important the partition filters are pushed to the source system when queries are submitted for refresh operations. To push filtering down means the datasource should support query folding. For some data sources that don't support query folding, incremental refresh to be very slow, and the process can run out of resources either in the Power BI service or in the on-premises data gateway if used. So, above warning suggests you use data sources supporting query folding.

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)