Supplies are limited. Contact info@espc.tech right away to save your spot before the conference sells out.
Get your discountScore big with last-minute savings on the final tickets to FabCon Vienna. Secure your discount
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