Incremental Refresh - Data Refresh Issue

[PowerAnu]

Hi 

After setting Incremental Refresh in Desktop with in power query ,

I see the below screenshot  in power bi service , 

how to trace why the incremental refresh is not happening in scheduled refresh case.?? while first time on demand 1 , ondemand 2 seems have achieved incremental refresh.

Please help me with the above how to trace or find solution for this.

[v-diye-msft · Accepted solution]

Hi @PowerAnu 

You can check your local gateway log or use fiddler to trace the operation logs.

Reference link:

Troubleshooting Power BI Gateway - Personal

Fiddler Trace

Fiddler is a free tool from Telerik that monitors HTTP traffic.  You can see the back and forth with the Power BI service from the client machine. This may show errors and other related information.

Setup Logs

If the Personal Gateway, fails to install, you will see a link to show the setup log. This could show you details about the failure. These are Windows Install logs, or also knows as MSI logs. They can be fairly complex and hard to read. Typically the resulting error will be at the bottom, but determining the cause of the error is not trivial. It could be a result of errors in a different log, or be a result of an error higher up in the log.

Alternatively, you can go to your Temp folder (%temp%) and look for files that start with Power_BI_.

Note:

Going to %temp% may take you to a subfolder of temp.  The Power_BI_ files will be in the root of the temp directory.  You may need to go up a level or two.

[nandukrishnavs]

@PowerAnu  Which are the connectors you are using?

[nandukrishnavs]

@PowerAnu 

https://youtu.be/JsJWBr1_ktQ

[PowerAnu]

Sql server as a data source supports query folding , can see native query at each step.