How To Extract data from Sharepoint Online using Power BI

By 26/09/2019 October 8th, 2023 No Comments

If you want to extract data from Sharepoint online using Power BI then this code snippet might help to connect to Sharepoint online

Code Snippet as below:

Source = SharePoint.Files(“”, [ApiVersion = 15]),
#”Sprint Backlog.xlsx_ Forms/” = Source{[Name=”Sprint Backlog.xlsx”,#”Folder Path”=” Forms/”]}[Content],
#”Imported Excel” = Excel.Workbook(#”Sprint Backlog.xlsx_ Forms/”)

#”Imported Excel”

Leave a Reply