Forum Discussion
Best practice to avoid expanding columns when connecting to Dynamics CRM?
Community ChampionI'm not sure what you are referring to as it being something to avoid. Expanded columns in that context are just merged columns from a joined table, and that is what they are there for. You just don't have to do the merge manually in the Power Query editor. But you should only expand the columns you need. If there are 50 columns, and you need 3, just check off those 3 before expanding.
You definitely do NOT want to load a bunch of unnecessary tables in to the model just for lookups. That will perform much worse for your users and that all happens real-time while they are clicking and filtering the report, whereas doing it in Power Query might result in a longer refresh, but once loaded, DAX has to do very little work, which is better for the end user.
I am not referring to expanding columns for a merge, rather expanding columns that are already embedded to the entity, (these appear in yellow and each row appears as record). For example if I am looking at the account entity and owning team is a column of that entity that needs to be expanded to view the ID column.
This is a major performance hit on the report and I am looking for a solution to get the ID column without expanding the column and taking the performance hit, if there is another way when working with Dynamics CRM?