Forum Discussion
Power query - parse all JSON column
hi, I tried to upload a sample pbix file but the page does not support it. I can add a sample data as table and add the power query code if needed
You can upload the PBIX to a cloud service such as OneDrive, Google Drive, Dropbox, or to a Github repository, and then share the URL.
Hi nadavsnn ,
There seems to be a problem with this part of the code:Please try:
if Value.Is(value, type record) thenValue.Is - PowerQuery M | Microsoft Learn
Best Regards,
Gao
Community Support TeamIf there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!How to get your questions answered quickly -- How to provide sample data in the Power BI Forum -- China Power BI User Group
thanks, Gao
I still get this error:
Expression.Error: The name 'expandJsonObject' wasn't recognized. Make sure it's spelled correctly.
in the advanced editor everything is ok. after I close it I get an error