The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. 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