Forum Discussion
Power BI vs. Excel Add-ons
If someone were to add Power Query, Power Pivot, and Power View to Excel. Can you do the same things that can be done with Power BI.
Hi Anonymous
I haven't tested this yet. But I think these components provide similar user experience.
https://docs.microsoft.com/en-us/power-query/power-query-what-is-power-query#power-query-experiences
for more details, you can review this article,
https://www.wallstreetmojo.com/power-bi-vs-excel/
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
I believe PBI is intended as a tool to share reports (and you have control of what data is seen by whom using Row Level Security), whereas Excel (with PQ, etc) is possibly more for deep data analyisis. Excel has the advantage that allows for easy user data input (it´s more flexible in that regard vs PBI). However, there are some DAX functions present in PBI which are not available in Excel (yet).
PBI also means that consuming reports is ubiquitous and simple. I don't feel comfortable sharing Excel workbooks where I lose control of the data management and run the risk of others tampering with the content more easily than in a PBI report.
4 Replies
Hi Anonymous
I haven't tested this yet. But I think these components provide similar user experience.
https://docs.microsoft.com/en-us/power-query/power-query-what-is-power-query#power-query-experiences
for more details, you can review this article,
https://www.wallstreetmojo.com/power-bi-vs-excel/
Best Regards,
Community Support Team _Tang
If this post helps, please consider Accept it as the solution to help the other members find it more quickly.
Anonymous , Under the data Tab-> Get data -> After that a popup similar to power bi will open, use transform data to open power query
After that you will see query and connection on right, use edit to go to power query
Or Under data tab -> Try query and connection
I believe PBI is intended as a tool to share reports (and you have control of what data is seen by whom using Row Level Security), whereas Excel (with PQ, etc) is possibly more for deep data analyisis. Excel has the advantage that allows for easy user data input (it´s more flexible in that regard vs PBI). However, there are some DAX functions present in PBI which are not available in Excel (yet).
PBI also means that consuming reports is ubiquitous and simple. I don't feel comfortable sharing Excel workbooks where I lose control of the data management and run the risk of others tampering with the content more easily than in a PBI report.
