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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
kishoregan
New Member

Direct query refresh is taking long time

Hi,

 

We are in the process of changing the direct query method to import method for which the data source is Teradata views. The pbix has 9 queries in which each of the query has around 2 millions of rows and it is taking huge time say around 6+ hours for refreshing the data after changing the direct method to import method.

 

Is there any way to optimize this, help is appreciated.

 

Thanks,

Kishore

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @kishoregan,

 

You may try to disable 'Parallel loading of tables' in PBI Desktop options (it's enabled by default):

 

parallelload.png

 

 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @kishoregan,

 

You may try to disable 'Parallel loading of tables' in PBI Desktop options (it's enabled by default):

 

parallelload.png

 

 

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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