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,

 

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