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

Error using Detect Data Changes Re: Incremental Refresh

Hey all,

 

I've configured Incremental Refresh to work on my table using the settings below.

 

image.png

 

However when i attempt to enable "Detect Data Changes" on the same table using the settings above, i get the following error.

 

image.png

 

Anyone have any idea what this is about?

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Regular Visitor

Re: Error using Detect Data Changes Re: Incremental Refresh

Hey all,

Issue resolved. After recreating the model and trying all sorts, i renamed the column in "Detect Data Changes" to exclude spaces in the name and hey presto, it worked!!

 

Not sure thats in documentation anywhere.

 

So essentially i changed my column from [Sync Date Time] to [SyncDateTime] and the error disappeared.

View solution in original post

5 REPLIES 5
Highlighted
Super User III
Super User III

Re: Error using Detect Data Changes Re: Incremental Refresh

Hi @BobbyEire ,

 

do you get errors when publishing?

Which Power BI desktop version are you using?

 

Did I answer your question?
Please mark my post as solution, this will also help others.
Please give Kudos for support.

I work at KUMAVISION AG , one of the world's largest
implementation partners for Microsoft Dynamics. #BetterTogether

Highlighted
Regular Visitor

Re: Error using Detect Data Changes Re: Incremental Refresh

Hey Mwegener,

 

The version of Power Bi desktop I have is Version: 2.81.5831.821 64-bit (May 2020).

 

It won;t allow me to apply the changes because of the error so i can't publish them

Highlighted
Community Support
Community Support

Re: Error using Detect Data Changes Re: Incremental Refresh

Hi @BobbyEire ,

 

If you select the Detect data changes checkbox, you can select a date/time column used to identify and refresh only the days where the data has changed. This assumes such a column exists in the source system, which is typically for auditing purposes. This should not be the same column used to partition the data with the RangeStart/RangeEnd parameters. The maximum value of this column is evaluated for each of the periods in the incremental range. If it has not changed since the last refresh, there is no need to refresh the period. 

 

For reference:

Incremental refresh in Power BI

 

Best Regards,

Amy 

 

Community Support Team _ Amy

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Highlighted
Regular Visitor

Re: Error using Detect Data Changes Re: Incremental Refresh

Hey Amy, 

 

I'm using 2 separate columns:

 

[Sync Created Date Time] for the incremenatl refresh

[Sync Date Time] for Detecting Data changes.

Highlighted
Regular Visitor

Re: Error using Detect Data Changes Re: Incremental Refresh

Hey all,

Issue resolved. After recreating the model and trying all sorts, i renamed the column in "Detect Data Changes" to exclude spaces in the name and hey presto, it worked!!

 

Not sure thats in documentation anywhere.

 

So essentially i changed my column from [Sync Date Time] to [SyncDateTime] and the error disappeared.

View solution in original post

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Top Solution Authors