Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register 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.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
Check out the February 2026 Power BI update to learn about new features.
| User | Count |
|---|---|
| 53 | |
| 52 | |
| 39 | |
| 15 | |
| 15 |
| User | Count |
|---|---|
| 94 | |
| 81 | |
| 34 | |
| 29 | |
| 25 |