Steve G
asked on
Power Query missing data on Close and Load
I'm using Power Query within Excel connected to Microsoft Dynamics 365 online with an OData connection. For most of the data I am pulling it is working well, however I am stuck on a strange issue in which the preview in the Query Editor shows certain fields pulling through OK, but these don't then pull through when Closing and Loading. In fact, the full-row preview in Query Editor also shows these as null, even though they are populated within the same instance of Query Editor in the 'horizontal row' preview (difficult to explain, I've attached a screenshot).
The fields in question are from the many-end of a one to many relationship with the initial source table, and I wondered if this was the issue. But I have other examples in the same query of different one-to-many relationship data items pulling successfully through in the Close and Load.
Any help in understanding and overcoming this issue would be greatly appreciated, thanks
PowerQueryMissingData.JPG
The fields in question are from the many-end of a one to many relationship with the initial source table, and I wondered if this was the issue. But I have other examples in the same query of different one-to-many relationship data items pulling successfully through in the Close and Load.
Any help in understanding and overcoming this issue would be greatly appreciated, thanks
PowerQueryMissingData.JPG
ASKER
Thanks for the reply - I had expanded the table (the table you can see in the screenshot relates to a different data relationship). Having done more investigation the issue seems to be with Dynamics lookups. The Query editor main preview seems able to interpret lookups and pull back values from a looked-up object, but on Close and Load it cant. Does this seem plausible?
This question needs an answer!
Become an EE member today
7 DAY FREE TRIALMembers can start a 7-Day Free trial then enjoy unlimited access to the platform.
View membership options
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
You should expand the Table and select the desired column to fetch from the table and then close and load as BRB.name and BRB.creation are already there in other columns.