cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
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

Accepted Solutions
Highlighted
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
Highlighted
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

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors