Forum Discussion
Missing Column Names From CRM
I'm using Power BI Desktop to connect to our 2016 CRM Online instance. When I load a table the Field list only shows a fraction of the columns that are actually in the table. If I go into Edit Queries, I can see that the query is actually returning the correct number of columns, but when it shows them in the Fields list, many are missing.
I've tried this with:
- Opportunities - we have 202 columns, but only 83 show in the Field list
- Accounts - 313 columns, 148 in Field list
- Leads - 230 columns, 114 in Field list
Any suggestions? Am I doing something wrong?
So, you need to use the little arrows in the column header to expand that cell.
It's because those aren't columns in the same table. They are records from a different entity. Every picklist field in CRM is a lookup to a record in another table. So is every lookup field. Basically if the field isn't free text, date, or number it's probably going to show up in the query editor as a record. That has little to do with Power BI and more to do with the way CRM organizes and stores data.
12 Replies
I'm not sure it is a good idea to try to import all the columns from CRM although what you are describing is odd. I would highly recommend that you wittle down the number of columns to what is important. I realize that does not fix the behavior but a LOT of those fields in CRM are useless.
A good suggestion - I can just get the columns I actually need. So I tried it.
Unfortunately, it didn't work. I selected 23 columns...and only 8 appeared in the Field list.
Clearling there's something wrong. In our setup or in what I'm doing.
Can you give me the fields that you are retrieving and from what table? I'll try to replicate it. We also use CRM Online.
