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.
Hi
For the last 3 years of using power bi I have been modelling fact and dimensions myself in PB desktop. Alway trying to aim for a star schema where possible or at least as close as possible (see example below)
However were are moving to a new management system and our data warehouse team have decided to model facts and dimensions in SQL . This means I now inport a sigle facts table with dimension columns that can be expanded. Example below shows these DIM columns with values
Can you advise how best I can use this type of table or should I request the warehouse team provide single facts and and single dim tables for me to model myself.
I would be greatfull for eny advise or resources to learn more about this type of table.
regards
RIchard
Solved! Go to Solution.
Ideally you would get the warehouse team to provide the separate fact and dimension tables as you suggest, but if that's not an option then you could use Power Query. You could reference the main query shown in your screenshot, once for each dimension table you want to create, delete the unneeded columns from each reference and then expand out the remaining column. That would seem like quite a bit of work for you though.
You definetely don't want all the facts and dimensions combined into one table. That would cause performance problems and also introduce problems with SUMMARIZECOLUMNS and autoexist.
Thank you for the prompt response john75 I am with you about asking the warehouse team to resort back to seperate fact / dim tables
Richard😀
Ideally you would get the warehouse team to provide the separate fact and dimension tables as you suggest, but if that's not an option then you could use Power Query. You could reference the main query shown in your screenshot, once for each dimension table you want to create, delete the unneeded columns from each reference and then expand out the remaining column. That would seem like quite a bit of work for you though.
You definetely don't want all the facts and dimensions combined into one table. That would cause performance problems and also introduce problems with SUMMARIZECOLUMNS and autoexist.
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 |
---|---|
110 | |
97 | |
78 | |
64 | |
55 |
User | Count |
---|---|
143 | |
109 | |
89 | |
84 | |
66 |