Incremental Refresh Concerns / Data Publish - Doesn't work even when set up as per the documentation

[anshul1123]

Hi Everyone, 

I have a concern on two points with incremental refresh,

1. I have 2 different dashboards (both with Incremental refresh set up ) running the same SQL query from Teradata via ODBC connect , in one dashboard the entire query refreshes each time , on the second it fails with time out. Both have been set up as per manual , However I do not know where i am going wrong.
2. the second concern is with Publish where i keep getting the below error for the past few days :

Please Help! Much Appreciated.

Thank you,

Anshul 

[v-diye-msft · Accepted solution]

Hi @anshul1123 

1.  Please add the SQL query with extending command timeout like:

let
    Source = Sql.Databases("Servername", [CommandTimeout=#duration(0, 0, 35, 0)]),
    TestGatewayDocs = Source{[Name="databasename"]}[Data],
    dbo_Product3 = databasename{[Schema="dbo",Item="Product3"]}[Data]
in
    dbo_Product3

2. Not sure the root cause, please kindly use the latest desktop and clear the data source permission, make sure all steps correct, if still not help , please provide the desktop trace for better research.

[anshul1123]

How can i send over the trace?

[v-diye-msft]

Hi @anshul1123 

Please upload it to the Onedrive for business, and share the link here.

[lbendlin]

The only sure way to check if incremental refresh actually works is to connect to the XMLA endpoint with a tool like SSMS or DAX Studio and to look at the partition refresh timestamps.  If you only see one partition then incremental refresh does not (yet) work.