Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
One of our datasets makes use of Azure Databricks as its datasource and is set for Incremental Refresh on the last 3 days. In order to make sure the refresh takes as little time as possible during financial closing, we use the Enhanced Refresh API to only refresh the transactional tables on an hourly basis.
However, we noticed that when one of the queries to fetch the daily partitions fails, a second query is immediately fired that is no longer folded and thus tries to fetch all rows and columns from our Databricks.
Is this some failsafe that Power BI tries to execute when it can't properly update a partition or is this related to our data source or API request? We are desperately looking for a solution.
The API request looks as followed:
Thanks in advance!
Sounds more like a bug. You might be able to work around it by setting the retry count to 0.
You can raise an issue at https://community.fabric.microsoft.com/t5/Issues/idb-p/Issues . If you have a Pro license you can consider raising a Pro ticket at https://admin.powerplatform.microsoft.com/newsupportticket/powerbi
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.