How to extract data from a new pdf file (weekly) and append that data to a dataset?

Hi Anonymous ,

According to your description, I think you can do it. I give an example to illustrate the steps.

1.Connect the PDF in Power BI Desktop through Get Data>PDF.

2.It is presented in table format when connected.

3.Now you can reference values in the table. For example you want to get the Sales of Category D, create code like this:

Table.SelectRows(#"Page001",each [Category]="D")[Sales]{0}

Result:

I attach my sample below for your reference.

Best Regards,
Community Support Team _ kalyj

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.