Forum Discussion
Sharepoint Upload
I have the following sample code to bring a sharepoint file into Power BI using M-Code - Power Query. The code allows me to bring in 1 tab in the escel file.
Is there a way to bring in multiple tabs?
let
Source = SharePoint.Files("https://vyukaexcelu.sharepoint.com/", [ApiVersion = 15]),
Filter = Table.SelectRows(Source, each ([Name] = "sample.xlsx")), File = Filter{[Name="sample.xlsx",
#"Folder Path"="https://vyukaexcelu.sharepoint.com/shared_files/"]}[Content],
#"Imported Excel" = Excel.Workbook(File),
#"Sheet or table selection" = #"Imported Excel"{[Item="Sheet1",Kind="Sheet"]}[Data],
#"Promoted Headers" = Table.PromoteHeaders(#"Sheet or table selection", [PromoteAllScalars=true])
in
#"Promoted Headers"
Thank you,
1 Reply
- AnonymousNot applicable
Hi Rocky_Brown ,
Below are some similar posts for you to check if they could help you.
https://powerbi.microsoft.com/en-us/blog/combining-excel-files-hosted-on-a-sharepoint-folder/
https://community.powerbi.com/t5/Power-Query/Import-CSV-Files-Then-Total-Them/td-p/532288
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.