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
Thats helped me figure out the plan. Create another dimension at the lowest level of granularity with the ID, And move the ID out of the fact table. Its a bit of work but it needs to be done.