Forum Discussion
Solved
Star Schema Modelling issue when using Multiple datasets
Hi,
I think I have made a modelling mistake that on a single sta schema doesnt cause issues. Its because Im now pulling multiple data sets together and those data sets hold a star schema each.
...
No I cant share this pbix file.
And its all sorted. I created the dimension with the ID. removed the ID from the fact table. And I kept the higher dim with just the type in it for the star schemas at the higher level of granularity.
Took a while but it was worth it and everything is working well now
