Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

  • v-diye-msft's avatar
    v-diye-msft
    Icon for Community Support rankCommunity 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. 

     

    • Anonymous's avatar
      Anonymous
      Not 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!