Forum Discussion
Power BI Data model
Hi Anonymous ,
According to your case description and the data modeling diagram you have provided so far, your five-dimensional tables are connected to your two fact tables using one-to-many one-way relationships according to your needs, I think this is a more secure and feasible solution, in the perspective of data modeling has avoided many-to-many inter-table relationships, for complex DAX queries, my understanding is that your inter-table relationships do not cause complex DAX queries, but complex calculated columns that you create in existing models, Calculated tables will cause large resource consumption and load time when refreshing, specifically for report analysis, you can try the desktop performance analyzer tool to find out the DAX operations or visuals that take more time.
Best Regards,
Neeko Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
My query is , I have a requirement to create a matrix visualization, by pulling the column from DIM1 and Fact2. How can i achieve this without enabling Bidirectional and writing DAX expressions on the report?
However, I need to build the datamodel and give it to my users to create reports for self service visualization. Users wont be able to write DAX queries.
Awaiting for your help.