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.
Greetings Experts,
I have uploaded my data an the automatic relationship has sorted my tables below. From the traditional star schema, it looks to be a "reverse star schema". Fact tables are the end points and DimTables are the center of star. This of course is causing report issues because I'm not able to filter what I need and PowerBI says there's no relationships between fact tables. Anybody know a quick way to transform this "reverse Star Schema" into a "traditional star schema" where the fact tables are center and DimTables are end points?
Hi @Jlicht
I'm afraid there's no quick way to achieve that.You may transform them manually.
Regards,
@v-cherch-msft That is sad to hear, but I guess some data is build like that. Do you know how I would go about manually editing the data to fit a star schema in this situation? Just as a general process?
User | Count |
---|---|
77 | |
77 | |
68 | |
67 | |
49 |
User | Count |
---|---|
108 | |
105 | |
93 | |
83 | |
64 |