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

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.