Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hey,
This might be a rather boring (read stupid) question, I am dealing with a large file coming in more than 100 columns but I want to know exactly how many columns I am importing into the Power Bi. How can I count them as the Max. showing on the bottom left of the page is frozen at 60.
Thanks
Solved! Go to Solution.
Hi @Alirezam
In Power Query you can use the Table.ColumnCount function. So if you load your main data into a table called Table, create a blank query called ColumnCount and use this code in it
let
Source = Table.ColumnCount(Table)
in
Source
Regards
Phil
Proud to be a Super User!
This is what I was looking for . Thank you for the solution.
Hi @Alirezam
In Power Query you can use the Table.ColumnCount function. So if you load your main data into a table called Table, create a blank query called ColumnCount and use this code in it
let
Source = Table.ColumnCount(Table)
in
Source
Regards
Phil
Proud to be a Super User!
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
110 | |
99 | |
93 | |
88 | |
70 |
User | Count |
---|---|
166 | |
133 | |
129 | |
102 | |
98 |