Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Anonymous
Not applicable

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 schema is updated in the database. But the refresh should just directly bring in the new field in the table.

What is the solution for this. Is this possible?

Please let me know.

TIA.

 

Regards.

2 REPLIES 2
Pragati11
Super User
Super User

Hi @Anonymous ,

 

What do you mean by model change here when a new column is added?

Will your relationships within the tables change when new columns are introduced?

Can you add more details please?

 

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

 

Thanks,

Pragati

Best Regards,

Pragati Jain


MVP logo


LinkedIn | Twitter | Blog YouTube 

Did I answer your question? Mark my post as a solution! This will help others on the forum!

Appreciate your Kudos!!

Proud to be a Super User!!

Anonymous
Not applicable

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.

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.