Power Bi and Power Pivot different results on same model

[vytas]

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. 

[v-stephen-msft · Accepted 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

https://support.microsoft.com/en-us/office/hierarchies-in-power-pivot-002cf883-3b5f-497c-bfa1-ab2271...

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 · Accepted solution]

Solution in Power Pivot Forum - https://techcommunity.microsoft.com/t5/excel/data-model-relations-not-working-properly-in-power-pivo...

[v-stephen-msft · Accepted 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

https://support.microsoft.com/en-us/office/hierarchies-in-power-pivot-002cf883-3b5f-497c-bfa1-ab2271...

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.

[amitchandak]

@vytas , Put sum(Sales Quantity)  and check, I doubt power pivot showing 0 /blank value too

[vytas]

I don't want sum quantites - i want to see every quantitie was sold by product as i see in Power BI Matrix.