Forum Discussion
Slow performance within Power BI Desktop, Query editor, Applied Steps.
Hi all, I tried connect to the Dynamics CRM Content pack online without sucess. So now i'm trying to connect to Dynamics through either Power Query or directly with Power BI desktop. I am fac...
Does anyone have a solution to this yet?
Using Dynamics CRM Online is so painfully slow in Desktop that it's pretty much unusuable.
I've started to try and use a tool called XRM Tool Box, this has a plugin called Power BI Option-Set Assistant. This will map all your option sets for you, massively reducing the number of steps that needs to be taken in Power BI when editing your query. Give it a go. Here's a link to how it works: http://www.gapconsulting.co.uk/news-resources/blogs/entryid/141/xrmtoolbox-the-powerbi-option-set-assistant