Forum Discussion
Copy Power BI Data Model to Excel
Good Morning, I build out a data model in Power BI, but I am not able to build the P&L I was wanting as easily as I though in Power BI. I'd like to move this work over to excel as its own new que...
Uzi2019, thanks for the quick response. The data model I built out is connected to my SQL Server, I just want to setup or move the connection directly into excel through power query and power pivot so that I can delete or not rely on the original pbix file. Are you saying that won't be possible?
hi MBenton8
Ohh, I got your point. please refer below video for better understanding.
You can change the connection ie data source from power query. it is possible.
SQL to Excel
https://www.youtube.com/watch?v=VIwsu4BbUMU
Excel to SQL
https://www.youtube.com/watch?v=MgU3sSI0y-AI hope I answered your question!
