0 votes
in PowerBI by
What is the difference in data modeling between Power Pivot for Excel and Power BI Desktop?

1 Answer

0 votes
by

The Power BI desktop supports a bi-directional cross-filtering relationship, calculated tables, security, and Direct Query options. However, Power Pivot for Excel has single relationships and supports import mode only. Also, it cannot be defined as Power Pivot for Excel.

...