Forum Discussion
Power BI as ETL tool for Excel?
I have a large Excel workbook being used as a dashboard. I'm still using Excel because PBI is not as user friendly for copy/paste, Print to PDF, and also because several people do not have a BI Pro l...
mahoneypat
Microsoft Employee
Microsoft EmployeeFYI that Power BI Desktop is completely free (no pro license needed), and the query editor is nearly identical between Excel and Power BI. I suspect that there is something wrong with your query that could be optimized. If you share your M code from the Advanced Editor and some more info (# rows, etc.), someone from the Community can likely propose a fix.
Pat