Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.
Hi there. I have a huge fact table with approximately 200 million rows.
I need to reduce the model size by using aggregations. So I created two principal aggregation tables: dates (4k rows) and sellers (40k rows).
The question is: how can I work with both of them? For example: sales by seller x on date y?
P.S.: I can't create a table with both seller and date because it would be huge as well (40k * 4k = 160 million rows).
Hi,
Create a relationship (Many to One and Single) from the 2 Fact tables to the 2 Dim tables.
I did this, but it doesn't find the aggregation relationship between seller and date in the same table (obviously because they are in separate tables). Is there any way for the two tables to interact even though they are separate?
Hi,
Share an abridged version of your PBI file and show the expected result very clearly.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
143 | |
77 | |
63 | |
51 | |
47 |
User | Count |
---|---|
212 | |
82 | |
61 | |
60 | |
57 |