Forum Discussion
Any way to change data source without using PowerBI desktop client?
I'm trying to change the data source for a set of reports from a local Excel file to a OneDrive file. I don't see a way to do that using the online service -- all the tips I've found online say to use the desktop client, but I use a Mac, so I don't think there's a desktop client available. I'm hoping to avoid having to recreate the reports. Does anyone know of a way to repoint a report to a different source without using PowerBI desktop? I'm new to PowerBI, so any suggestions appreciated.
Hi, shfleming
It’s my pleasure to answer for you.
According to your description,If you don’t want to recreate the report, it’s really difficult to change the data source.
The method az38 provided also requires setting parameters in the desktop.
So maybe it takes you some time to install and run Power BI desktop on a Virtual Machine,then change the data source.
You can set-up a Windows Virtual Machine on Azure, Google Cloud or AWS
Azure: https://azure.microsoft.com/en-us/services/virtual-machines/
AWS: https://aws.amazon.com/getting-started/tutorials/launch-windows-vm/If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
2 Replies
- az38
Community Champion
Hi shfleming
you can try to use PowerShell to change data source.
Complete guides you can find here
https://docs.microsoft.com/en-us/power-bi/report-server/connect-data-source-apis
here you can find guide to install powershell on macbook https://docs.microsoft.com/en-us/powershell/scripting/install/installing-powershell-core-on-macos?view=powershell-7.1
- v-janeyg-msft
Community Support
Hi, shfleming
It’s my pleasure to answer for you.
According to your description,If you don’t want to recreate the report, it’s really difficult to change the data source.
The method az38 provided also requires setting parameters in the desktop.
So maybe it takes you some time to install and run Power BI desktop on a Virtual Machine,then change the data source.
You can set-up a Windows Virtual Machine on Azure, Google Cloud or AWS
Azure: https://azure.microsoft.com/en-us/services/virtual-machines/
AWS: https://aws.amazon.com/getting-started/tutorials/launch-windows-vm/If it doesn’t solve your problem, please feel free to ask me.
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.