Forum Discussion
Power Query connection to SSAS Database much slower than Power Pivot Connection
My preference is to always use Power Query for loading data into Power Pivot, however last week I hit an issue where it was taking 3+ minutes to refresh a simple connection to a SSAS database. I ...
It's possible that the query we're generating is inefficient. If you are willing to send me the the M query you are using in a private message, I can take a look and see if there is something in it which isn't being folded correctly.
Thanks for replying Alex, I'll be back at the client next week and will send you the M code
Cheers
Wyn