Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Refresh the Sharepoint Excel file Dataset in Power BI Service

Hi,   I use an Excel file in Sharepoint as datsource to my Dashboard. In Power Bi Desktop , I use the 'Web' option of datasource to connect this file and provide the Sharepoint URL until the path ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi Gilbert,

 

It is Sharepoint Online, but when I access it Power BI Dekstop, I'm selecting the Datasource type as 'WEB'. 

Is that creating the issue?

 

Thanks

SVee

GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
7 years ago
Hi there

That should be fine, just make sure that it is using the SharePoint.com in the URL?
  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    Hi Gilbert,

     

    Yes it uses https://____ .sharepoint.com.................. in the beginning of the URL.

     

    Thanks

    SVee

    • GilbertQ's avatar
      GilbertQ
      Icon for Super User rankSuper User
      7 years ago

      hi Anonymous 

      Make sure it starts in the Advanced Editor with the following below

       

      Source = Excel.Workbook(Web.Contents("https://domain-my.sharepoint.com/personal/gilbert_fourmoo_com/Documents/Presentations/Dataflows/Dates%20tables.xlsx"
      • Anonymous's avatar
        Anonymous
        Not applicable
        7 years ago

        Hi Gilbert,

         

        Please find below the screenshot of the Advanced Editor,