Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Modelling data in Power BI or Excel/Power Pivot

Hi Experts, I have been learning power query, power pivot and power BI. I’m now trying to tie everything together. The end game is I want to publish a Power BI dashboards.   I have built a mock up...
Need Help
  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago
    Hi Anonymous ,
     
    Although PowerPivot has some data storage capability, as a built-in plug-in of Excel, its performance cannot match that of Power BI
    Desktop and SQL Server.
     
    Here is a blog about the performance comparison of PQ in Excel and power Bi desktop:https://www.thebiccountant.com/2017/05/14/performance-considerations-for-bom-solution-in-excel-and-powerbi/ 
     
    (Note: This link contains a reference to a third party World Wide Web site. Microsoft is providing this information as a convenience to you. Microsoft does not control these sites and has not tested any software or information found on these sites; therefore, Microsoft cannot make any representations regarding the quality, safety, or suitability of any software or information found there. There are inherent dangers in the use of any software found on the Internet, and Microsoft cautions you to make sure that you completely understand the risk before retrieving any software from the Internet.)
     
    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi Anonymous,

 

Almost no difference,It's just that some DAX functions can't be used in power bi.

When you import power pivot into the power bi desktop, the refresh will still synchronize with power pivot.

 

Best Regards,

Liang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickl