Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Schema change in database

Hi, I have a table in which there can be a new field added at any point of time. No deletion or column name change will happen, just new fields. I do not want to update the model everytime the sche...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi,

 

There wont be any impact in the relations at the model level in Power BI.

Example:

I have the following fields in the database:

 

StatusID     CompanyId       Field1   Field2   Field3       Field4
167ArizonaUgandaBrazilIndia

 

This structure can change any time a new field is added in the table.

I have created a procedure to handle that at the database level.

Now, when I imported the table in Power BI desktop, it had only the above fields. If new Field5 is added at DB level, without doing changes in the model, is it possible that Field5 shows up in the Desktop.

I am a newbie in Power BI so may be I am not using the right terminologies.

But this is what I want to know if it is possible to do in PowerBI desktop.

 

Thanks.