Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
@jcso , I doubt you can add a column automatically in Matrix. If that is row value(Unpivot Data), then it can add
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.
User | Count |
---|---|
53 | |
35 | |
20 | |
15 | |
14 |
User | Count |
---|---|
94 | |
78 | |
37 | |
22 | |
18 |