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
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,

       

      • GilbertQ's avatar
        GilbertQ
        Icon for Super User rankSuper User
        7 years ago
        Hi there, that should then prompt you under the credentials for the different authentication