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 nowJuly 7 - July 17 | Round 2 of the Power BI Dataviz World Championships. Don't miss your chance! Learn more
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.
Join us in Barcelona for FabCon and SQLCon, the Fabric, Power BI, SQL, and AI community event. Save €200 with code FABCMTY200.
Join Fabric Data Days 2026: 60 days of free live/on-demand sessions, challenges, study groups, and certification opportunities.
| User | Count |
|---|---|
| 23 | |
| 22 | |
| 18 | |
| 17 | |
| 13 |
| User | Count |
|---|---|
| 63 | |
| 44 | |
| 42 | |
| 40 | |
| 39 |