Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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 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.
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_.
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.
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 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.
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_.
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.
Sql server as a data source supports query folding , can see native query at each step.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.