Forum Discussion
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...
GilbertQ
Super User
Super UserHi 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?
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?
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
- GilbertQHi 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.