Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi there,
The error occurred when I tried to load files in the folder into PowerBI. Please see below snapshot.
Please tell me how to solve the errors.
Thanks a lot
Can you please tell me how to edit the queries so they no longer look for Jan? There is a column 'Jan' there actually. I don't know why the query overlook it.
The query shows: = Table.AddColumn(#"Filtered Hidden Files1", "Transform File", each #"Transform File"([Content]))
Good day Eastwindy,
The highlighted step is invoking the query "Transform File" (the third of the helper queries listed in the panel on the left of the screen shot). It is invoking it with a parameter of the current row of the [Content] column. "Transform File" is performing some operation on Content where it expects but is not seeing a column "Jan". When the query was originally built the data will have contained a "Jan" column but it looks like that is missing now. You could edit the queries so they no longer look for Jan.
Hope this helps a little
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
39 | |
20 | |
20 | |
13 | |
12 |