Really appreciate that you answered. Though I apologies! this has really nothing to solve my question. If I just had to count the column in that table, I could simply do that with
Select Count(*) From Information_Schema.Column Where Table_Name = 'My Table Name'
But my question was, could we (Without re-altering Power BI design again and again) automatically pull all the columns and show in table visual.
To be honest, I can actually solve it in some way, that is - applying pivoting functions in Stored proc with Dynamic SQL and then pull the whole table as just 3 static column... like, Primary Key, Field, Value and then use it in Matrix etc. But the real issue is that (what I mentioned in my question already) that number of rows are ~ 1million lets say and columns as of now ~ 66. so if I try such transposing operation it will turn into 65million records, so its not very efficinent I thought. That's why I am looking for an expert opinion here.
Those who are experience with .Net or Web developements etc. they will also know such situation where they need to use Select * - to bind GridView so, that additional column coming in such table will be auto displayed. I was looking such in Power BI.
