Forum Discussion
Sharepoint and move database connection
Hello, I made my dashboard in powerbi dekstop and connected a excel database to it. Now they want me to upload those two files in SharePoint so that the people can edit the Excel database so the...
Greg_Deckler
Community Champion
Community ChampionI may not be reading this right, but it sounds like you want to move your data source. Typically, you do this using Advanced Editor. Create a new query that connects to the new location of the data source. For this query, go into Advanced Editor and copy the Source line. Go to the original query, Advanced Editor and replace the Source line.
Sometimes you have to do the Navigation line as well.
Make a backup before you do this.