Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
In the star schema shown below, it was possible to make one of the fact tables bidirectional in order to link the fact tables without the key of the master table. However, as the number of data and parameters increases, the calculation of the Power BI measure becomes very heavy. I would like to know how to deal with this problem
So I found "User-defined aggregations". Is it possible to reduce the load by this?
Solved! Go to Solution.
@Anonymous , You have a concept of aggregations, but the table need to be in direct query mode for an import aggregate
https://docs.microsoft.com/en-us/power-bi/transform-model/aggregations-advanced
@Anonymous , You have a concept of aggregations, but the table need to be in direct query mode for an import aggregate
https://docs.microsoft.com/en-us/power-bi/transform-model/aggregations-advanced
Thank you for your reply.
It turns out that this is not a relation issue, but a solution to the issue with direct queries.
thank you.
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
87 | |
84 | |
66 | |
49 |
User | Count |
---|---|
131 | |
110 | |
96 | |
70 | |
67 |