Load data from PDF to Power Query

AUDISU · ‎09-26-2022

Hi All,

Im trying to get data from PDF. When I load data from PDF to power query it shows me some data but it does not make sense.

Anyone knows the reson for that.

Thank you.

amitchandak · ‎09-26-2022

@AUDISU , DO you have a single table of multiple tables?

Check the steps, you might have modified a few steps in power query . Like if it shows multiple tables, then filter a table and expand

If this does not help
Can you share sample data?

Share with Power BI Enthusiasts: Full Power BI Video (20 Hours) YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

AUDISU · ‎09-26-2022

@amitchandak

I filtered a table and expanded, but still have same issue.

I opend this PDF in Word app and it shows me the same issue.

Thak you

Anonymous · ‎09-29-2022

Hi @AUDISU ,

How did you connect to PDF in Power BI Desktop? Could you please share the PDF file(or some screenshot for pdf file) and the applied codes of the related queries in Advanced Editor? Thank you.

And you can refer the following links to connect to PDF in Power BI Desktop:

Connect to PDF files in Power BI Desktop

Read and Import Data from PDF Files using Power BI

Best Regards