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...
Power BI works well as an ETL tool for Excel since Power Query can handle most extraction, transformation, and loading steps directly. I found this blog post useful - it explains how to set up ETL workflows in Power BI efficiently, which can help when preparing data for Excel.