Dynamically Detect and Display additional column added in Source Table

[RKM]

I have a table [Around 1 million record and 66 columns] in SQL DB and entire dataset is displayed in Power BI dashboard.

Occasionally new Columns might get added to that table (No Delete Allowed).

Is there a possibility that we can make our Power BI to automatically detect and pull and display that new column when its added in source?

[RKM]

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. 

[aj1973]

Hi @RKM 

To make Power Bi detect a newly added columns you can create a card where you count them columns then pin the card to a dashboard and create an Alert feature. Here's how to count columns https://community.powerbi.com/t5/Desktop/Count-number-of-columns-measure/m-p/799707

To get columns added to your table automatically the model needs to be connected in a Direct Query mode however the columns won't be added and displayed into canvas automatically.