Forum Discussion

Riddhi_06's avatar
Riddhi_06
Frequent Visitor
4 years ago

Getting exact column count when columns are more than 1000

How can we get an exact column count when the column count is exceeding 1000 in power bi? In power query it is shown as 999+ What can be done?
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi Riddhi_06 ,

 

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(TableName)
in
    Source

 

 

Best Regards,

Stephen Tao

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.