Forum Discussion

rhyslowe's avatar
rhyslowe
New Member
7 years ago
Solved

Cannot link a Sharepoint Excel file to Desktop PowerBI

Hi all,   I'm very new to PowerBI, I'm struggling to pull data from an excel data we have shared on an ogrniazational sharepoint site.   I think the issue is to do with the link that I'm using, I...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    rhyslowe,

    The root URL of your sharepoint site is https://xxxxx.sharepoint.com/sites/<sitename>, right? If so, please use the URL https://xxxxx.sharepoint.com/sites/<sitename>/Shared%20Documents/<Yourexcename>.xlsx to connect to your file.

    Please note that to connect to Excel that is located under Documents of SharePoint online site, use the URL below.
    https://xxxxx.sharepoint.com/sites/<sitename>/Shared%20Documents/<Yourexcename>.xlsx

    To connect to Excel that is located under a folder in SharePoint online Documents, use the URL below.
    https://xxxxx.sharepoint.com/sites/<sitename>/Shared%20Documents/<Foldername>/<Yourexcename>.xlsx

    Regards,
    Lydia

    Regards,
    Lydia

gpiero's avatar
gpiero
Icon for Skilled Sharer rankSkilled Sharer
7 years ago

HI rhyslowe

 

as you can se below this is one method using Web Content

 

let
    Source = Excel.Workbook(Web.Contents("https://MyCompany.sharepoint.com/sites/Wmsh/en/PBI_Data/902GoodsReceiptAreaStatus/902Em.xls"), null, true),
    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data],
    #"Promoted Headers" = Table.PromoteHeaders(Sheet1_Sheet, [PromoteAllScalars=true]),
    #"Changed Type" = Table.TransformColumnTypes(#"Promoted Headers",{{"Tipo magazzino", Int64.Type}, {"Ubicazione", type number}, {"Materiale", type number}, {"Tipo stock", type text}, {"Stock speciale", type text}, {"Numero stock speciale", type text}, {"Stock totale", Int64.Type}, {"Stock disponibile", Int64.Type}, {"Stock da immagazz.", Int64.Type}, {"Stock da prelev.", Int64.Type}, {"Unità magazzino", type text}, {"N. fabbisogno", type text}, {"Durata", Int64.Type}, {"Lotto di controllo", type number}, {"Magazzino", type text}, {"Ultimo movimento", type date}, {"Data entrata merci", type date}})
in
    #"Changed Type"

 

This is the site

 

https://MyCompany.sharepoint.com/sites/Wmsh/en/PBI_Data

and this is the site + document library

 

 

https://MyCompany.sharepoint.com/sites/Wmsh/en/PBI_Data/902GoodsReceiptAreaStatus/902Em.xls