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.
Is there anyway to dynamically choose PDF tables when connecting to PDF as a data source? Sometimes there may be an extra page so my table that would normally be 006 might be 007 for one PDF.
Or I was thinking I could import all the pages and append them and then transform data from there, but I'm not sure what to do if the PDF is one page shorter than usual as that query would fail because it can't find that page? Is there a way for a query to try and then if fails, skip over and continue?
Hi @Anonymous ,
Your demand is a good idea, while it is not supported to dynamically choose PDF tables when connecting to PDF as a data source in Power BI currently. You can post your new idea in Idea Forum , add your comments there to improve Power BI and make this feature coming sooner.
Best Regards,
Amy
Community Support Team _ Amy
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@Anonymous you can try otherwise statement to handle the error.
https://docs.microsoft.com/en-us/power-query/handlingerrors
https://blog.gbrueckl.at/2013/12/error-handling-in-power-query/
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop shop for Power BI related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
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 |
---|---|
110 | |
95 | |
76 | |
65 | |
51 |
User | Count |
---|---|
146 | |
109 | |
106 | |
88 | |
61 |