Get certified for free when you join Fabric Data Days 2026 and dive into Fabric, Power BI, SQL, AI, and other essential data skills.
Join nowTry your skills in the Power BI Dataviz World Championship! Round one ends June 26. Join now
I keep encountering an error with expanding a collumn and then applying the query change:
1. Opening record
2.Putting it into a table
3. Expanding It into the full table
4. Applying query change. Error finding correct column
Does anyone have any ideas what might be going on?
Solved! Go to Solution.
Glad to hear that. Next time, you may try the try expression.
Hi @dscheid,
Which column are you trying top retrieve?
I don't get it correctly. Please give more details and will try to help.
Ninter.
Hi there,
I am trying to access all the rows and columns to make a visualization. I am starting with JSON data from a web source. To get it into a usable format I need to excute a query to get it into a spreadsheet format by exanding columns. I get to the format I want, but when I hit "Close and Apply" it throws the error listed above.
Could you please the internet link if it is not private ( sensitive data)?
Ninter
I reinstalled the application, and it seems to be working now. Must have been a small bug. Thank you
Glad to hear that. Next time, you may try the try expression.
Don't miss out on Data Days, June 15 through August 7. Learn Fabric, Power BI, SQL, AI and more.
Check out the May 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 24 | |
| 22 | |
| 21 | |
| 20 | |
| 14 |
| User | Count |
|---|---|
| 59 | |
| 53 | |
| 41 | |
| 31 | |
| 31 |