Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
My data is JSON. After doing af lot of transformation, I end up with an issue. When expanding the then column with records, I loose a lot of data.
This record fails when expanding
This record expands correct.
Clearly Power Bi does not undestand the example since it writes "a" instead of "Value".
The data are descriping a resource. The diffence in the underlying XML is, that unsuccesfull records have one CustomProperties value - and succesfull records have more than one.
Succesfull example
Unsuccesfull record example
How should this be handled in Power Query?
Hi, @toafk
I wonder which connector you are using. The problem is related to the structure of the file. Could you show us the transformations applied to the data? Do mask sensitive data before uploading. Thanks.
Best Regards
Allan
Hi @toafk
I am not sure what value you want to extract, and you provided XML instead of JSON...are you using some sample query generated by PBI? Have you tried to add a custom column to extract XML or JSON? Can you provide your M code?
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
100 | |
54 | |
21 | |
12 | |
11 |