Compare Performance Power Pivot in Excel vs BI

[Titiwai]

I have one question about power pivot performance. At work we have one big folder with 1500 ish and counting csv files, equivalent of 4 million lines and and we want to use the combine folder connector. The options are either use Power Pivot in Excel or use Power Pivot in Power BI. 

Excel option come with the flexibity to update file path which hosted on network drive. It is already implemented but refreshing is not fast.

BI option will probably have to be on sharepoint due to network drive mapping is different for each user (minus point) but given the interface is identical between the two, will the performance improve, if so by what magnititute? Is there a tool to measure?

[Idrissshatila]

Hello @Titiwai ,

yes, you could connect dax studio to excel to connect the Power pivot.

check how to do so here https://daxstudio.org/docs/tutorials/getting-connected/

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Idrissshatila]

Hello @Titiwai ,

you could use Dax Studio to see the performance in Power BI.

check it out here https://daxstudio.org/

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Titiwai]

Thank you, but I wonder if DAX studio applies to Power Pivot in Excel.. The comparison is something I am really after.