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!

Incremental Refresh Data Error - 'DD.MM.YYYY format

Hi there,

Have been experimenting with Incremental Refresh and have noticed that any reports outputting dates with an apostrophe in front (to maintain leading 0s etc) are not recognised as dates. Desktop and online reports not utilising Incremental Refresh happily transform said columns into dates. As soon as those reports have incremental refresh attached however, then they will not refresh online.

Please note the column causing the issue wasn't the one being used for the incremental refresh parameters, it was just in the dataset.

 

Thanks

Andy

Status: New
Comments
v-qiuyu-msft
Community Support

Hi @DataWizard,

 

I have tested on my side, but not able to reproduce the issue. What's the detail error information showed in refresh history? 

 

How did you configure incremental refresh in Power BI desktop? Would you please share pbix file with us? You can upload it to your OneDrive or Dropbox, send the share link to me via private message. 

 

Best Regards,
Qiuyun Yu