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
AndyDC's avatar
AndyDC
Regular Visitor
6 years ago

Hi,

I've ran a SQL Profiler session via Azure Data Studio and the only SQL query I can see running is the following.

 

-- network protocol: TCP/IP
set quoted_identifier on
set arithabort off
set numeric_roundabort off
set ansi_warnings on
set ansi_padding on
set ansi_nulls on
set concat_null_yields_null on
set cursor_close_on_commit off
set implicit_transactions off
set language us_english
set dateformat mdy
set datefirst 7
set transaction isolation level read committed
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
6 years ago
Hi there

You will have to look at all the events when using Azure Data Studio to see the event which sends the query down to the Azure SQL DB.

It does take a little bit of digging to find the query but it should be there, it is for me.
  • AndyDC's avatar
    AndyDC
    Regular Visitor
    6 years ago

    Hi,

    I can see the SQL that is being sent if I don't enable the Detect Data Changes feature.  Unfortunately if it's enabled then the SQL never gets sent to the SQL Database.

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      6 years ago
      Hmm that looks like a bug to me then. I would suggest logging a support ticket.
      • betizad's avatar
        betizad
        Icon for Helper I rankHelper 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