Forum Discussion
Populating a Master Sheet using a snippet of data from multiple Excel files in sub folders
I am desperate for some help on this one. I will do my best to explain. Feel free to ask questions if I haven't made myself particularly clear. I have a Sharepoint location that holds a number of f...
If all files have the same structure you may use From SharePoint folder connector with Power Query to transform and combine all files at once.
If it'll be used in Power BI in general you don't need Master Excel file. With same query as above you may dataflow using Power Query Online. Dataflow could be loaded into semantic model. Or in Excel if you need it for some purposes.