Analyze in excel direct query vs import

[Anonymous]

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 ?

[v-cazheng-msft · Accepted solution]

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!