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!Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.
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.
Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!
Check out the October 2025 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
11 | |
9 | |
8 | |
8 |