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
Icon for Super User rankSuper User
6 years ago
Hi there

I would think that it should not cause any issues.

What happens when you run query profiler on the database can you see the query get there?
  • 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.