Forum Discussion
Helper IIIData loads in Power Query but not in Power BI
IanR Yeah, the column names or values in yellow are what I'm referring to. If you can expand and dig in as you describe that is the functionality that will slow things down exponentially. I can't speak to the "why" or "where" in the processing, all I know is it kills the processing in Power BI.
There should be relationships that you can use in these entities to build relationships within Power BI. For all of the translations from ID to name or description, those you will most likely have to re-create in Power BI. You can build those columns of values within the table, or add them as seperate dimensions if the lists are huge and relate them via the ID.
Another tool I've used to see the actual names vs. what CRM (Dynamics 365) shows is the XRM Toolbox. You can download the schema and it is extremely helpful as it shows you all the value transformations for dropdowns, etc.
I've used the above methods, only pulling data, and everytime the data loads in under 5 minutes.
Helper IIIHi Eno1978,
Do you mean the columns that start off containing 'Record' or 'Table'? Those are the only column contents that I can see that are not in the standard font colour. A couple of questions:
The Table columns I had a hunch that I had to be careful with - as they are looking at other tables in CRM. However, despite the lack of query folding, won't the heavy lifting for these, the looking up in other tables, be done on the source server and therefore be relatively quick?
Clicking on the double headed arrow symbol in the header for the Record columns opens a dialog that offers a list of options; mostly Id, Logical Name, Name and Row Version. For ID columns I don't know of any other way of getting at the data. For example, in the OpportunitySet table all the useful ID columns, such as opportunity ID or parent contact ID, are of the Record type. Without expanding these columns I don't think I could bring these IDs into the model. Ordinarily I would only select Id and possibly Name. I have started to use the Name column less as I can look these values up in the root tables (e.g. use ContactSet table for parent contact name) but I don't see a way of not expanding these to get to the ID. Am I missing a trick?
Thanks
Ian
IanR Yeah, the column names or values in yellow are what I'm referring to. If you can expand and dig in as you describe that is the functionality that will slow things down exponentially. I can't speak to the "why" or "where" in the processing, all I know is it kills the processing in Power BI.
There should be relationships that you can use in these entities to build relationships within Power BI. For all of the translations from ID to name or description, those you will most likely have to re-create in Power BI. You can build those columns of values within the table, or add them as seperate dimensions if the lists are huge and relate them via the ID.
Another tool I've used to see the actual names vs. what CRM (Dynamics 365) shows is the XRM Toolbox. You can download the schema and it is extremely helpful as it shows you all the value transformations for dropdowns, etc.
I've used the above methods, only pulling data, and everytime the data loads in under 5 minutes.