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
Hello ,
I have data model in Power Bi. Connected same data model in Excel Power Pivot and getting different results.
Model is simple 2 tables - Product an Product Sales.
In PowerBi i get result i want - under product just sales quantities from that product, but in Power Pivot it is different - seems like there is no connection between tables , why ? (Implicit , explicit measures ? )
Power BI Matrix report (no explicit measures created)
Power Pivot Report
Thank You in advance.
Solved! Go to Solution.
Hi @vytas ,
Since it is not a Power BI issue, you can go to the Power Pivot forum to consult.
From what I have learned, your Power Pivot table seems to lack a hierarchy. Please kindly refer to
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Solution in Power Pivot Forum - https://techcommunity.microsoft.com/t5/excel/data-model-relations-not-working-properly-in-power-pivo...
Hi @vytas ,
Since it is not a Power BI issue, you can go to the Power Pivot forum to consult.
From what I have learned, your Power Pivot table seems to lack a hierarchy. Please kindly refer to
Best Regards,
Stephen Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@vytas , Put sum(Sales Quantity) and check, I doubt power pivot showing 0 /blank value too
I don't want sum quantites - i want to see every quantitie was sold by product as i see in Power BI Matrix.
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 |
---|---|
94 | |
92 | |
82 | |
71 | |
49 |
User | Count |
---|---|
143 | |
121 | |
112 | |
58 | |
57 |