Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have my Facts Table. I also have Dimentions Tables created by Get Data: Excel Workbook (this workbook includes data that is exported from our software app containing my 7 Dimensions (7 relevant Columns).
First I made a total of 7 copies and reduced the columns to each have data relevant to my 7 'Dimensions': DIM Site, DIM Tariff, DIM Location, etc.
The data within changes on a monthly bases.
What is the process of updating my Dimension Tables (DIM Site, DIM Tariff, etc)
Thank you in advance.
Solved! Go to Solution.
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)
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.
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)
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.
Hi Polly,
Thank you for your comprehensive answer although please tell whether there is any alternative way of updating the Dimensional tables?
Many thanks,
Jola
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
98 | |
78 | |
65 | |
60 |
User | Count |
---|---|
148 | |
113 | |
97 | |
84 | |
67 |