Forum Discussion

dogbural's avatar
dogbural
New Member
11 months ago
Solved

transfer messy table from PDF extraction to tidy table

Hi, I have some invoices in PDF and would like to see if the data can be tabulised in the way I want. So, I bring PDF files to Power query and would like to tidy the appended table up.  Unfortun...
Need Help
  • v-veshwara-msft's avatar
    v-veshwara-msft
    11 months ago

    Hi dogbural ,

    Thanks for posting in Microsoft Fabric Community.

    Thanks DataNinja777  for outlining the general approach using Power Query - that’s exactly the right direction.

     

    I created a sample Power BI file where the invoice, PO, line, and quantity details are extracted into a structured table. You can download it and click Transform Data to review the applied steps and final output. Please tweak the steps as needed to fit your source data.

     

    Hope this helps. Please reach out for further assistance.

    Thank you.

v-veshwara-msft's avatar
v-veshwara-msft
Icon for Community Support rankCommunity Support
11 months ago

Hi dogbural ,

Thanks for posting in Microsoft Fabric Community.

Thanks DataNinja777  for outlining the general approach using Power Query - that’s exactly the right direction.

 

I created a sample Power BI file where the invoice, PO, line, and quantity details are extracted into a structured table. You can download it and click Transform Data to review the applied steps and final output. Please tweak the steps as needed to fit your source data.

 

Hope this helps. Please reach out for further assistance.

Thank you.