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.
Background:
I am trying to create a Power BI data set that imports in all the *.JSON files from a specific mapped network drive.
Current Issue:
I've followed the steps outlined in the link below...
http://www.dutchdatadude.com/loading-multiple-json-files-using-power-query/
After completing the function, I am able to enter a specific path and filename successfully.
However, when I attempt to add the custom column (the last few steps), I get the following error message:
"An error occurred in the 'LoadJSON' query. Expression.Error: We cannot convert a value of type List to type Text."
Details:
Value=List
Type=Type
Any help would be appreciated. I'm a newbie...
Hi , did you get a solution? I have the same issue..
Thanks!
It would be good to have some screenshots of where your query has stuck.
The error says that you have a List where it expects a Text. looking at the article this could be in multiple places, so if you can attach a draft of the query from the advance query dialog that will aid the conversation as well.
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 |
---|---|
102 | |
53 | |
21 | |
13 | |
11 |