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
KamilSzpyrka
Helper III
Helper III

Refresh Dataset in 2 batches to avoid two hour time-out

Hello,

 

I'm facing an issue when I cannot complete a refresh due to two hour refresh limit. My datasource is Teradata and I'm loading 10 different tables. 

 

My main question is:

1. Is it possible to divide refresh in PBI Service into 2 batches (5 tables + 5 tables) to avoid the time out issue?

 

I also would appraciate if anyone could help with below.

2. Is it worth to change .NET Driver for ODBC for better performance for TERADATA? 

3. Is the below error message the one that returns PBI due to two hour timeout?

KamilSzpyrka_0-1675342672512.png

 

Many Thanks in advance, Kamil

3 REPLIES 3
wikkleyn
Solution Supplier
Solution Supplier

Hi @KamilSzpyrka 

1. If you are using Premium, you can split the refresh by using a dataflow. 

2. We have tried both and found the .NET Driver for ODBC didn't perform better. I have found that odbc sources add additional maintenance on the gateway. 

3. The timeout is on Teradata. You can overwrite that in the advance settings of your query. Also, check with the Teradata dba if they aren't throttling your user. 

Hello @wikkleyn and thanks for help.

 

Just to be more specific regarding point 2 - are you trying to say that ODBC will be faster? What do you mean by additional maintanance on the gateway? 

 

Thanks! Kamil

ibarrau
Super User
Super User

Hi, let's see

1- The only way to refresh specific items would be with dedicated capacity and the enhanced refresh API. If you have shared capacity (pro license) then no.

2- I really don't know the answer for this one.

3- That's not the PowerBi two hours timeout. The error says that it was aborted by a user. There might be a timeout over teradata to cancel querys if they take too long. If power query let you write a query for teradata it also let you configure a timeout for the query (advance settings when connecting). Even though if the query takes 2 hours you can't increase that timeline and make it work.

You can look for reducing or downsizing data model in order to help with the time range of the refresh.

I hope that helps.


If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

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.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

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