Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

Change Data Source from Local Desktop to Sharepoint

Hi,

 

I have built 25 reports and have hosted the input excel files in my local machine. Now I want to map the already created dashboards with the same excels hosted on the Microsoft Teams sharepoint. How can I do that?

Need Help
Show and Tell
  • DarrenLau's avatar
    DarrenLau
    7 years ago

    Are you able to navigate to your Sharepoint/Teams site on a web browser using the following URL format?

     

    https://YOURCOMPANYNAME.sharepoint.com/teams/YOURTEAMNAME

    That would be the starting point to determine the correct URL and then you can determine the folder names/structure.

     

7 Replies

  • v-lili6-msft's avatar
    v-lili6-msft
    Community Support
    7 years ago

    hi, Anonymous 

    You could try this way:

    Download the pbix file, then open it in power bi desktop

    • Click on edit queries
    • Select the query
    • Advanced Editor
    • Go to the first step in the Query (always called Source) and change it there

    You can change the datasource from here.

    Then do apply , and republish it to power bi service.

    By the way: you'd better use copied pbix files to do these.

     

    Best Regards,

    Lin

  • DarrenLau's avatar
    DarrenLau
    Advocate I
    7 years ago

    Adding on to the reply.

     

    You can change the location by editing the Data Source Settings :-

     

     

    Click on each of the files located on your C:/ drive and replace with the corresponding Sharepoint URL.

     

    As per the previous reply, work on a copy of the PBIX in case of issues.

    • Anonymous's avatar
      Anonymous
      Not applicable
      7 years ago

      I am using Microsoft Team sharepoint. When I copy the excel link the sharepoint and try to put it in the new source, I get an error saying below-

       

      "The downloaded data is HTML, which isn't the expected type. The URL may be wrong or you might not have provided the right credentials to the server."

      • DarrenLau's avatar
        DarrenLau
        Advocate I
        7 years ago

        Hmmm, I am syncing via my personal Sharepoint/OneDrive directory (confusingly named, I know - in File Explorer, it's a OneDrive folder, but online it's a Sharepoint URL).

         

        Let me check how it works via Teams Sharepoint and come back to you.