Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone, how can load files in sharepoint folder without combining them? Every file has its own table/columns/content and all of them reside in the sharepoint folder. Im asking this as I think there should be a more efficient way to load tables to my data model rather than creating a new connection for each one of the files. Is this even possible? Copying creates an enormous transformation file. Thanks in advance 🙂
Hi @ronaldbalza2023 ,
You can have a single main query that is connected to a Sharepoint Folder and reference to that query to that connect to each file. This main query doesn't need to be loaded to the data model.
Query: SharepointMain
let
Source = SharePoint.Files(SharepointSite, [ApiVersion = 15])
in
Source
ReferencingQuery:
let
Source = SharePointMain,
#"Filtered Rows" = Table.SelectRows(Source, each [Name] = "MyFile.xlsx"),
in
Source
Proud to be a Super User!
Hi @ronaldbalza2023 ,
What do you mean by nothing? If you wan to connect to a file, you can just click on Binary right before the filename. Power BI then will try to figure out what the file type is and use the necessary data source function (Csv.Document, Excel.Workbook, etc).
Proud to be a Super User!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |