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

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
Anonymous
Not applicable

Analyze in excel direct query vs import

My data size is huge (about 6 million)

I am using direct query, when trying to build visuals in powerbi, because i have a slicer on date its not that bad, but when I analyze on excel, it takes forever when I drag drop columns, why is it that service is a bit faster but analyze in excel is slow ?

 

Question: In direct query mode, what happens when you Analyze in excel , and drag drop columns, behind the scenes the Oracle database is being hit directly ? If the answer is yes, maybe import mode analyze in excel is faster as compared to direct query analyze in excel ?

1 ACCEPTED SOLUTION
v-cazheng-msft
Community Support
Community Support

Hi @Anonymous 

Did you use Analyze in Excel to connect to the data created by the Direct Query or Import mode in the Service? Compared to Direct Query mode, Import relatively queries data faster because the data of the data source will be import into the model of the pbix file. Power BI will use its own query engine to query data. For Direct Query, data will reside in the data source and the data source undertakes the work of querying data, the duration of the queries will be primarily influenced by the performance of underlying data source and some other factors such as network situation.

 

Best Regards

Caiyun Zheng

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

 

 

View solution in original post

1 REPLY 1
v-cazheng-msft
Community Support
Community Support

Hi @Anonymous 

Did you use Analyze in Excel to connect to the data created by the Direct Query or Import mode in the Service? Compared to Direct Query mode, Import relatively queries data faster because the data of the data source will be import into the model of the pbix file. Power BI will use its own query engine to query data. For Direct Query, data will reside in the data source and the data source undertakes the work of querying data, the duration of the queries will be primarily influenced by the performance of underlying data source and some other factors such as network situation.

 

Best Regards

Caiyun Zheng

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

 

 

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

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