cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Super User
Super User

combine binaries in power query - how to pull only a specific worksheet in excel

i have a sharepoint folder i am pulling hundreds of excel templates into power bi, but i want to separate each pull by worksheet, is there a way of specifying the worksheet name when you pulling from sharepoint?  


Did I answer your question? Mark my post as a solution.
Proud a to be a Datanaut!
1 ACCEPTED SOLUTION

Accepted Solutions
Community Support Team
Community Support Team

Re: combine binaries in power query - how to pull only a specific worksheet in excel

Hi @vanessafvg,

 

After pulling all excel files from SharePoint folder, there is a column listing all worksheets' names, from whcih you can do a filter to get specific worksheet you need.

 1.PNG

 

You can also apply a filter in Power Query code, reference: Consolidate Multiple Excel Files in SharePoint using PowerQuery

 

Best regards,

Yuliana Gu

 

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 REPLY 1
Community Support Team
Community Support Team

Re: combine binaries in power query - how to pull only a specific worksheet in excel

Hi @vanessafvg,

 

After pulling all excel files from SharePoint folder, there is a column listing all worksheets' names, from whcih you can do a filter to get specific worksheet you need.

 1.PNG

 

You can also apply a filter in Power Query code, reference: Consolidate Multiple Excel Files in SharePoint using PowerQuery

 

Best regards,

Yuliana Gu

 

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.