speed of loading data Power query vs Power pivot

[Barbora Risova]

I'm getting my data from SQL Server Analysis Services Database. It takes appreciably more time to load data thru Power Query rather than Power Pivot even thought the results and actions taken are the same.
As i prefer to load data into Power Query is there some optimizing method that would save the time. Also i would like to know how exactly does the Power Query gets the data.
I'm sort of new to BI.

 

[bestcourse4u]

A Step by Step guide to installing SQL Server 2008 simply and successfully with no prior knowledge Developers and system administrators will find this installation guide useful, as will seasoned DBAs. It will teach you the basics required for a typical, problem-free installation of SQL Server 2008, allowing you to add other components later if you wish.
http://www.bestcourse4u.com/database/

 

[Matt Allington]

I have seen the same behaviour. I mentioned it to Miguel Llopes at PASS BA Conf this year - he hadn't heard of it. He asked me to send a sample, but I have been too busy. If you have something you can share, maybe you can send a frown. I think something is wrong, and the difference is horrible in my view.