Forum Discussion
Missing Column Names From CRM
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.
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.
Thanks for that info - I was unaware.
Good community - thanks to both responders to my (it turns out) dumb question.
Well, right now the content pack isn't very useful if you have a bunch of customizations. Meaning you have to create it from scratch. However, my hope is that once you can download a content pack dataset to Desktop then you could create additional queries to import your custom stuff and marry it to the tables in the content pack dataset. That's the thought anyway.
One other thing to note on this. There is a Content Pack for Power BI Service that does all of this tedious work for you. Sometime in the future, you will apparently be able to download the dataset created by Content Packs.
Greg_Deckler how useful is that content pack if you have a bunch of customizations? Like if we have a bunch of our own additional custom entities for instance, are those be accessible through the content pack? We're on-premise right now but they're talking about going online, so I'm a little worried about my future.
That's what I was afraid of. Oh well, we're rebuilding our entire CRM from scratch so I'm going to have to redo all the reports no matter what. Thanks for the info. I'll definitely keep an eye on that.