What are some of differences in data modeling between power bi desktop and power pivot for excel?



What are some of differences in data modeling between power bi desktop and power pivot for excel?..

Answer / Saket Vishnoi

Power BI Desktop offers more advanced features like DAX formulas, dynamic calculations, and relationships between tables compared to Power Pivot for Excel. However, Power Pivot for Excel is still a powerful add-in that allows you to perform data modeling and analysis directly within Excel.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Power BI Interview Questions

What is Power BI Desktop?

1 Answers  


Define power bi?

1 Answers  


Name all the platforms for which power bi app is available?

1 Answers  


What are the parts of microsoft self-service business intelligence solution?

1 Answers  


Explain various parts of microsoft self-service bi solution?

1 Answers  


What are many-to-numerous connections and how might they be tended to in Power BI ?

1 Answers  


What is the essential prerequisite for a table to be utilized as a part of Power Map?

1 Answers  


For what reason do we require Power Query when Power Pivot can import data from for the most part utilized sources?

1 Answers  


What are the distinctive Excel BI include?

1 Answers  


What is question collapsing in Power Query?

1 Answers  


Can sql and power query/query editor be used together?

1 Answers  


What are content packs in Power BI?

1 Answers  


Categories