Forum Discussion
Change Database path in POWER BI ONLINE
Hello,
I'm aware that I can change the datasource inside power bi desktop.
My problem is that I've done all my project on my the Power BI Desktop in my computer, but in the end, the datasource (excel spreadsheets) had to be located in another computer, because these spreadsheets need to be filled by other people.
I've already published my report online and installed gateways on the actual computer that the datasource should be, but I can't change the "Path" fileld when trying to Edit credentials
Is there any possible way to do this change without having to install the Power BI Desktop in the final computer and publishing it from there?
Thanks
Hi Anonymous
"but in the end, the datasource (excel spreadsheets) had to be located in another computer, because these spreadsheets need to be filled by other people."
You might consider to put the file on the Onedrive/Sharepoint, that everyone can edit it. then use the desktop to connect it and publish the report into service. Or you can connect the excel in the service directly.
Literally, if you'd like to edit the path whose datasource has been already added in the gateway, plz add a new one.
3 Replies
- Greg_Deckler
Community Champion
Anonymous - Not to my knowledge.
- v-diye-msft
Community Support
Hi Anonymous
"but in the end, the datasource (excel spreadsheets) had to be located in another computer, because these spreadsheets need to be filled by other people."
You might consider to put the file on the Onedrive/Sharepoint, that everyone can edit it. then use the desktop to connect it and publish the report into service. Or you can connect the excel in the service directly.
Literally, if you'd like to edit the path whose datasource has been already added in the gateway, plz add a new one.
- AnonymousNot applicable
I've installed the Power BI Desktop on the final computer, but I believe this SharePoint solution would have worked just fine
I'll keep that in mind for the next Reports
Thanks!