Forum Discussion
Unable to change path for datasource in uploaded pbix file in powerbi.com
This remains a problem without a true solution - anytime you do anything to a datasource (change the location, rename, etc), the old/legacy datasource persists upon upload to the PBI site. Uninstalling everything and rebuilding connections is not a solution, but a huge inconvenience bordering on dealbreaker for using an expected-scalable solution.
Ideally, yes - all datasources, when added, would stay exactly where they are, but that's not always the case. In my situation, I've updated a datasource and changed the location from drive to drive on our server - the result was fine within the PBI Desktop environment, but once pushed to the PBI site, the old datasources remain - since there's no way for me to enter credentials for a file that doesn't exist anymore, it won't allow me to refresh on the PBI site any longer.
For instance, let's say I have an excel datasource located here: C:\datasource.xls
If I move that same datasource to E:\datasource.xls, update everything in the PBI Desktop file (so it works flawlessly), then push it to the PBI site, I now have two datasources called datasource.xls - one located on my C drive, one on the E drive. I've reviewed everything - the datasources under options, the individual queries...there is no mention of this in the file itself.
It appears that the data persists on the upload in some sort of "cached" state on MSFT's servers - the result is that you have a dashboard looking for data that isn't there. Instead of overwriting the file, it just appends it almost.
- Luuk10 years agoRegular Visitor
Same problem here when changing the data source from a development server to a production server.