Solved: Get data from multiple pdfs (inside a sharepoint d...

Anonymous · ‎09-27-2019

Our team saves client output in pdf format in a sharepoint document library. The pdf all have the identical structure and can successfully get data from the new PDF data connector for one pdf. How can we have one table in power query that contains (appends) all of the pdfs and retain the client id attached to each pdf? Thank you

ImkeF · ‎09-28-2019

You have to transform your query into a function and apply it in an add-column-step on a table that holds your client id somewhere. Please check out this article for more details: https://exceleratorbi.com.au/combine-excel-workbooks-power-query-method-1/

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries

View solution in original post

ImkeF · ‎09-28-2019

You have to transform your query into a function and apply it in an add-column-step on a table that holds your client id somewhere. Please check out this article for more details: https://exceleratorbi.com.au/combine-excel-workbooks-power-query-method-1/

Imke Feldmann (The BIccountant)

If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!

How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries