ETL

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:

let
Source = SharePoint.Files(“https://XYZ.sharepoint.com/”, [ApiVersion = 15]),
#”Sprint Backlog.xlsx_https://XYZ.sharepoint.com/Reporting Forms/” = Source{[Name=”Sprint Backlog.xlsx”,#”Folder Path”=”https://XYZ.sharepoint.com/Reporting Forms/”]}[Content],
#”Imported Excel” = Excel.Workbook(#”Sprint Backlog.xlsx_https://XYZ.sharepoint.com/Reporting Forms/”)

in
#”Imported Excel”

Leave a Reply