cancel
Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.

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
PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors