Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Victor_V
Frequent Visitor

2nd on-folded query fired after error in Databricks

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:

Victor_V_0-1695989194738.png

 

Thanks in advance!

 

 

 

1 REPLY 1
lbendlin
Super User
Super User

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

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors