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!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
I'm connecting to a table from Big Query which is updated every month with a new column.
I would like to have a Matrix in Power BI just replicating that table, with all its columns, without having to manually select every single column into the Matrix Visual. And just by refreshing the data source, the Matrix would be updated to. Better yet if the even the refreshing is automatic.
This is the first time I use Power BI and I'm struggling for the last 2 hours trying to find a how to on this. I guess it should be simple, but I have no clues on how to to it.
hmm, thanks! I've found a different way to structure the data, to avoid having the need to add extra columns
@jsco. Im facing the same challenge. Could you please share your your way of working around this issue.
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 20 | |
| 11 | |
| 10 | |
| 4 | |
| 4 |
| User | Count |
|---|---|
| 33 | |
| 30 | |
| 19 | |
| 11 | |
| 10 |