Forum Discussion

AndyDC's avatar
AndyDC
Regular Visitor
6 years ago

Pro Incremental Refresh with Detect Data Changes fails

Hi, I'm getting an error when I enabled the Detect Data Changes option in the new Pro Incremental refresh feature.  My data source is an Azure SQL Database in North Europe.  Without enabling this fe...
Need Help
GilbertQ's avatar
GilbertQ
Super User
6 years ago
Hmm that looks like a bug to me then. I would suggest logging a support ticket.
betizad's avatar
betizad
Helper I
6 years ago

I do face the same issue. I can perfectly make it work on Azure SQL DB and Cosmos-DB as long as "Detect data changes" is disabled. As soon as I enable the feature, I get the following error.

Something went wrong

There was an error when processing the data in the dataset.
Please try again later or contact support. If you contact support, please provide these details.
MessageResource name and Location need to match. Resource name: EUI. Location: Polling_36686F87_B3FA_4760_A613_9C6D47A37170.
Cluster URIWABI-WEST-EUROPE-redirect.analysis.windows.net
Activity IDc2cc7ddf-b1f3-4870-8b1f-d5aef96805b1
Request ID7b525d2b-b2c4-48cb-b657-6ec698ff73fa
Time2020-02-27 13:48:50Z

 

  • shaunwilks's avatar
    shaunwilks
    Helper V
    6 years ago

    Yes I can add to the weight of people suggesting this is a bug in the Gateway/PBI refresh.

     

    I re-wrote all my queries to support folding.

    6 queries in total, 4 use Detect changes the otehr 4 just normal incremental settings.

     

    After finding that the two with detect changes were failing I disabled just that option on the incremental referesh and tried again.

    Of course the entire refresh went through without an error so it was working well when Detect Changes was disabled.

     

    That now tells me there is a clear issue in Detect Changes for PBI PRO and Incremental Refresh