Updated PDF data source not refreshing :{

[Anonymous]

Hi, 

When my PDF dataset updates and the PDF page number increase due to there being more data, Power Bi will not refresh becacue there are more pages than the original PDF.

For example, if i start with the below and assuming the data takes up 12.5 pages, when the PDF data is updated but stays within 13 pages it updates fine, however, if the PDF updats and the data consumes  more than 13 pages it will not update.

Any help on this would be hugle appreciated. 

Thanks 

[v-angzheng-msft]

Hi, @Anonymous 

It is assumed that there is no sensitive information here, if there is, contact me to change it.

Here is a sample file created using the data you provided, which works as usual.
Note that all columns are on one page. I don't think this has anything to do with what the data is, this should be a problem with the operation.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[v-angzheng-msft]

Hi, @Anonymous 

Maybe this is an accidental problem, please make sure that your PDF file information has not changed, such as path, file name. I tested this problem. I tried to add page data to the same PDF file. The original PDF file had 8 pages. I copied the file and increased the number of pages to 16 pages. Click Refresh, and PowerBI successfully loaded the correct data. . Please make sure that there are no errors in your operation and try again.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

For info, this is the error message 

[v-angzheng-msft]

Hi, @Anonymous 

Since PDF files have many pages, it is necessary to create the same table header for each page, so that the data can be identified as the same table. If the page data except the first page does not have a table header, it will be identified as a different table in Power BI recognition and automatically add column names to the data, such as Column1, Column2, etc.

If your data from Excel, you can select "page layout" from Excel above - "page setup" - select print titles --sheet- Rows to repeat at top, click "OK" and then to export to PDF, this PDF page data have a header row.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hey Team _ Zeon Zheng,

Not quite there yet 🙂

I currently have a headers for each page but still not recognising as 1 table, see below.

Thanks 

[v-angzheng-msft]

Hi, @Anonymous 

How did you add the new data, I guess it might have something to do with the operation you did to add the new data.
If you are interested, here is my test data, I added the new data in Excel and re-exported it as a pdf file with the same name, changed the name of the first pdf file or deleted it, then clicked refresh and power bi successfully refreshed the data.
If you can work with my data, you can check your file manipulation process and then try again.

Hope this helps.

Best Regards,
Community Support Team _ Zeon Zheng
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

[Anonymous]

Hey Team _ Zeon Zheng,

That is interesting, becuase i tried your data and it works.

So, my data is auto generated reports from SAP in a PDF format, i would attached two copies for you to have a look at but it says File typ not suported when i try to drop in the box.

Kindest Regards

[v-angzheng-msft]

Hi, @Anonymous 

How to provide sample data in the Power BI Forum 

[Anonymous]

Material	Material description	Vendor	PO number	Quantity	Inventory Value	SLoc	Unit BWS-STD
00506411-0697	END PLATE AP KLIPPON	314805	4508277299	20	EA	6.00  GBP	0001	0.30
00506411-0731	INDICATOR,VISUAL	313676	4508297322	2	EA	8.02  GBP	0001	4.01
00506411-1156	PMD-200 PROG. MESSAGE DISPLAY	10010	4508168375	1	EA	1,658.88  GBP	0002	1,658.88
00506411-1278	TRANSFORMER,POWER,PRI 3300.00V	314548	4508270366	1	EA	224.03  GBP	0001	224.03
00506416-0183	VALVE, RELIEF	314839	4508273835	1	EA	104.35  GBP	0001	104.35
00506416-0183	VALVE, RELIEF	314839	4508275478	1	EA	104.35  GBP	0001	104.35
00506418-0617	PLIERS	313601	4508278947	1	EA	5.99  GBP	0001	5.99
00506479-0061	DOUBLE LEVEL TERMINALS	314805	4508277299	20	EA	34.80  GBP	0001	1.74
00506486-0036	SWITCH (CHAIN TENSIONER AUTO/MANUAL)	313243	4508264775	5	EA	132.85  GBP	0001	26.57
00509192-2052	CHAIN,CONVEYOR,SINGLE STRAND,83mm P	10010	4508064309	3	EA	5,357.43  GBP	0002	1,785.81
00509192-2052	CHAIN,CONVEYOR,SINGLE STRAND,83mm P	10010	4508064309	3	EA	5,357.43  GBP	0002	1,785.81
00534048-0005	FLOW METER	314839	4508273835	5	EA	2,575.95  GBP	0001	515.19
00809916-0000	TAPE, 3/4. ADHESIVE GLASS CLOTH	313676	4508297322	1	EA	22.50  GBP	0001	22.50
00823079-0000	OIL,TRANS,MIN,EP,320,MOBIL	316144	4508189277	140	L	386.40  GBP	0002	2.76
00900906-0491	BRG,RLR,SRB,80X170X58MM	315801	4508159062	1	EA	114.65  GBP	0001	114.65
00901246-0414	SEAL,ROTARY,5.5HD,4.5SD,.5W,NBR	10010	4508174309	3	EA	27.66  GBP	0002	9.22
00905319-0025	BRG,RLR,SRB,120X215X76MM	315801	4508093246	2	EA	357.64  GBP	0001	178.82
00906361-0012	SEALING WASHER,13/16,STEEL	10010	4508174228	25	EA	135.00  GBP	0002	5.40
00907234-1616	ADAPTER,1,JIC,NPTF,M,ZP	313120	4508176662	10	EA	33.50  GBP	0001	3.35
00910741-1212	ADAPTER,3/4,JIC,ORS,M,ZP	313120	4508273708	2	EA	6.36  GBP	0001	3.18
00910761-1616	ELBOW,90,1,JIC,M,FS,ZP	313120	4508176662	12	EA	100.80  GBP	0001	8.40
00913123-0007	SEAL,METAL FACE,DUO CONE,160HD,143ID	10010	4508174309	1	EA	30.33  GBP	0002	30.33
00950064-0003	CONE,BRG,TPR,RLR,65.88X43.76MM	312486	4508091862	2	EA	43.50  GBP	0001	21.75
00950116-0001	CONE,BRG,TPR,RLR,165.1X39.69MM	312486	4508157756	1	EA	47.86  GBP	0001	47.86
00950143-0004	CONE,BRG,TPR,RLR,53.98X33.24MM	312486	4508124975	4	EA	108.60  GBP	0001	27.15
00950169-0001	CONE,BRG,TPR,RLR,83.35X25.4MM	312486	4508157721	1	EA	13.72  GBP	0001	13.72
00950201-0001	CONE,BRG,TPR,RLR,247.65X22.23MM	312486	4508091862	2	EA	604.52  GBP	0001	302.26
00950261-0001	CONE,BRG,TPR,RLR,44.45X18.26MM	312486	4508091862	2	EA	48.06  GBP	0001	24.03
00960000-0001	CUP,BRG,TPR,RLR,190.5X46.04MM	312486	4508125052	5	EA	218.05  GBP	0001	43.61
00960000-0001	CUP,BRG,TPR,RLR,190.5X46.04MM	312486	4508125052	1	EA	43.61  GBP	0001	43.61
00960030-0001	CUP,BRG,TPR,RLR,120.65X31.75MM	312486	4508091862	1	EA	19.75  GBP	0001	19.75
00960042-0001	CUP,BRG,TPR,RLR,52.39X14.29MM	312486	4508091862	2	EA	6.10  GBP	0001	3.05

[v-angzheng-msft]

Hi, @Anonymous 

In fact, I am not sure what I should do with the above data.
Please make sure that the data you provide does not contain sensitive information. If it is not, please edit the above information and re-provide the data without sensitive information. It is best that you can provide the PDF file before and after adding the data, because I will test whether it can be in my environment Refresh normally, maybe I can find the reason for not working.

[Anonymous]

Hi Team _ Zeon Zheng,

Not to Worry, no sensative data, this is sample data.

Thanks

[v-angzheng-msft]

Hi, @Anonymous 

You can test the sample data above and then find the reason for not refreshing in your sample, if you have found the answer please let me know. It will help the others in the community find the solution easily if they face the same problem with you. Thank you.

[Anonymous]

Hi Zeon Zheng,

Thank you for your response.

See below, because the table description changes as the pages increase (1 - 13) to (1- 14) it doesn’t recognise the path for some reason. is there a way i can get it to ignore the page counts?

Thanks