Updating Dimensions Table

Hi Anonymous ,

What about the dimension tables? They are generally not updated very frequently, and this would typically be a manual process. However, due to the importance of the dimension tables and the role they place in our data model, it’s critical that there is a simple and robust method for updating this data. For example, we wouldn’t want to accidentally add a duplicate record to our Stores or Product Category table, as it will skew the results and mess up our reporting.

Due to the importance of the data, dimension tables are often considered part of an organization’s Master Data. Master Data Management can become a complex undertaking as organizations grow, requiring major effort to implement. However, for many organizations, a simple, but controlled way to update records in tables in a SQL database is sufficient. One way of doing this is with SQL Spreads.

More details: Power BI Fact and Dimension Tables 

I have also found a similar post, please refer to it to see if it helps you.

Updating dimension tables using SQL Server (BIDs or Data Tools) 

• The usual way to do things is to have a package which pulls out your Dimension data from your source system(s), and then load any new rows into your Dimension table. Then, when your Fact table load happens later in the process you look-up the ID column from the Dimension using the town name. Your Fact data should then be loaded into the Fact table with the ID for the relevant town as one of its column values.

Best Regards
Community Support Team _ Polly

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