Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello everyone and Happy New Year,
I'm trying to find a solution to model my data which look like a star model but my dimension table is in the center and the relationships are in the wrong direction
When I try to create a table with the informations of a contract from differents tables, I get an error "can't display the visual". To solve this problem, I have to use both relationships, but this is not recommended.
What is the best way to model this case
Thank you
Solved! Go to Solution.
Thank you for your help,
it works fine but I need to summarize (first, count,...) one column to display the others columns in the others tables.
Why I should use one summarized column to propogate the filter?
Best Regards!
Hi @wael
You can consider to create multiple dimension tables, in your model, you only have one dimension table and multiple fact tables, you may consider to create one more dimension tables bridge tables.
You can refer to the following link.
Data reduction techniques for Import modeling - Power BI | Microsoft Learn
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-xinruzhu-msft,
Thinks for replay,
The "Employement contract" serves as a bridge table, the ID column contains all unique value of ID_Contract. Your link refers to many-to-many relationship but the relationship is actually one to many.
The relationship filter propagation works properly from "Employement contract" with one table, but it does not work with severel tables.
If I add a bridge table witch colum should contains this table?
Best Regards!
Hi @wael
If you only have the current bridge table, and you want to filter other tables from this table, you can only consider changing the filter direction to both, because based on your description, if you want to filter tables on the current model, you can only change the filter direction to both.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thank you for your help,
it works fine but I need to summarize (first, count,...) one column to display the others columns in the others tables.
Why I should use one summarized column to propogate the filter?
Best Regards!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
90 | |
89 | |
79 | |
70 | |
68 |
User | Count |
---|---|
226 | |
129 | |
119 | |
84 | |
77 |