Forum Discussion
Connecting to Sharepoint Folder
I am trying to connect to a sharepoint folder via my PBI desktop. Once I connect with the root url and filter the relevant files (in power query) based on naming conventions:
--> say for example I filter all files that start with the word "Sales Report" --> I see the files Sales Report 1, Sales Report 2, Sales Report 3
--> I now want to combine these 3 files into one file, however all these files have two rows of useless data (Title etc) and then the actual table with data.
--> Is there any way I can remove the first two rows and then combine.
Any help would be greatly appreciated
1 Reply
- MFelix
Super User
Hi Anonymous ,
For this you need to use custom function that basically allows you to do that customization.
When you connect to the folder on the bottom you have several options
If you select the Combine and Transform this will create your custom function you only have the select the file you want to use has an example and the rest is created by PBI.
