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 sharepoi...
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.

     

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.

    • DarrenLau's avatar
      DarrenLau
      Advocate I
      7 years ago

      Okay, did some testing and this works -

       

      Teams Sharepoint URL looks like this :-

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

      The subfolder and path-to-file would add the following:-

      /Shared Documents/SubFolder1/Filename1.xlsx

      The complete URL would be 

      https://YOURCOMPANYNAME.sharepoint.com/teams/YOURTEAMNAME/Shared Documents/SubFolder1/Filename1.xlsx

      Query Editor code would look like this:

      let
    Source = Excel.Workbook(Web.Contents("https://YOURCOMPANYNAME.sharepoint.com/teams/YOURTEAMNAME/Shared Documents/SubFolder1/Filename1.xlsx"), null, true),
    Teams_Table = Source{[Item="Teams",Kind="Table"]}[Data],
    #"Changed Type" = Table.TransformColumnTypes(Teams_Table,{{"TeamIndex", type text}, {"Team", type text} })
in
    #"Changed Type"

      You can edit the query via Query Editor or edit in Data Source Settings replacing the C:/ path with the full URL path.