Need Help on importing pdf from a folder

[KuntalSingh]

Hi All

I have pdf file having multipal pages into folder and need to import all the pdf from a folder with all the pages in pdf file. I am only getting 1 page from every pdf not all.

Cnt. CT Date Start Duration Ext. Ext. Line Info Called Number Pul. Charge
No Time Starting Ending
____ ____ __________ ________ ________ ________ ________ ________ _______ ________________ ____ ________
4788 IC 03/07/2023 05:37:27 00:00:00 555 555 130 C 918969040624
4789 IC 03/07/2023 05:37:34 00:00:07 130 C 918969040624
4790 IC 03/07/2023 05:37:34 00:00:00 556 556 130 C 918969040624
4791 IC 03/07/2023 08:07:02 00:00:00 160 C 919935006161
4792 IC 03/07/2023 08:07:14 00:00:00 100 C 919935006161
4793 IC 03/07/2023 08:07:55 00:00:00 555 555 130 C 919935006161
4794 IC 03/07/2023 08:08:09 00:00:00 556 556 130 C 919935006161
4795 IC 03/07/2023 08:08:14 00:00:05 130 C 919935006161
4796 IC 03/07/2023 08:08:14 00:00:00 551 551 130 C 919935006161
4797 IC 03/07/2023 08:23:52 00:00:00 555 555 160 C 919935006161
4798 IC 03/07/2023 08:24:06 00:00:00 556 556 160 C 919935006161
4799 IC 03/07/2023 08:24:19 00:00:00 551 551 160 C 919935006161
4800 IC 03/07/2023 08:24:29 00:00:00 555 555 160 C 919935006161
4801 IC 03/07/2023 08:24:29 00:00:00 160 C 919935006161
4802 IC 03/07/2023 08:25:12 00:00:00 555 555 100 C 919935006161
4803 IC 03/07/2023 08:25:19 00:00:07 100 C 919935006161
4804 IC 03/07/2023 08:25:19 00:00:00 556 556 100 C 919935006161
4805 IC 03/07/2023 08:37:49 00:00:00 555 555 130 C 919935006161
4806 IC 03/07/2023 08:38:03 00:00:00 556 556 130 C 919935006161
4807 IC 03/07/2023 08:38:17 00:00:00 551 551 130 C 919935006161
4808 IC 03/07/2023 08:38:26 00:00:00 555 555 130 C 919935006161
4809 IC 03/07/2023 08:38:26 00:00:00 130 C 919935006161
4810 IC 03/07/2023 08:52:26 00:00:00 555 555 160 C 918700649925
4811 IC 03/07/2023 08:52:40 00:00:00 556 556 160 C 918700649925
4812 IC 03/07/2023 08:52:47 00:00:07 160 C 918700649925
4813 IC 03/07/2023 08:52:47 00:00:00 551 551 160 C 918700649925
4814 IC 03/07/2023 08:53:03 00:00:00 555 555 100 C 918700649925
4815 IC 03/07/2023 08:53:17 00:00:00 556 556 100 C 918700649925
4816 IC 03/07/2023 08:53:30 00:00:00 551 551 100 C 918700649925
4817 IC 03/07/2023 08:53:40 00:00:00 555 555 100 C 918700649925
4818 IC 03/07/2023 08:53:40 00:00:00 100 C 918700649925
4819 IC 03/07/2023 09:05:03 00:00:00 555 555 130 C 919935006161
4820 IC 03/07/2023 09:05:16 00:00:00 556 556 130 C 919935006161
4821 IC 03/07/2023 09:05:26 00:06:00 551 551 130 919935006161
4822 IC 03/07/2023 09:23:36 00:00:00 555 555 160 C 919935006161
4823 IC 03/07/2023 09:23:49 00:00:13 160 C 919935006161
4824 IC 03/07/2023 09:23:49 00:00:00 556 556 160 C 919935006161
4825 IC 03/07/2023 09:28:56 00:00:00 130 C 919422806303
4826 IC 03/07/2023 09:29:45 00:00:00 101 C 918527420314
4827 IC 03/07/2023 09:29:45 00:00:00 555 555 101 C 918527420314
4828 IC 03/07/2023 09:29:56 00:00:00 130 C 918527420314
4829 IC 03/07/2023 09:29:56 00:00:00 555 555 130 C 918527420314
4830 IC 03/07/2023 09:30:03 00:00:00 556 556 160 C 919422806303
4831 IC 03/07/2023 09:30:03 00:00:00 160 C 919422806303
4832 IC 03/07/2023 09:30:56 00:00:00 556 556 160 C 918527420314
4833 IC 03/07/2023 09:30:56 00:00:00 160 C 918527420314
4834 IC 03/07/2023 09:31:52 00:00:00 556 556 101 C 918527420314
4835 IC 03/07/2023 09:31:52 00:00:00 101 C 918527420314
4836 IC 03/07/2023 09:24:51 00:07:39 555 555 100 919935006161
4837 IC 03/07/2023 09:48:07 00:00:00 555 555 130 C 918527420314
4838 IC 03/07/2023 09:48:17 00:02:03 556 556 130 918527420314
4839 IC 03/07/2023 09:50:11 00:01:25 555 555 160 918630271919
4840 IC 03/07/2023 09:51:30 00:00:00 100 C 918700407523
4841 IC 03/07/2023 09:51:31 00:00:00 555 555 100 C 918700407523
4842 IC 03/07/2023 09:52:31 00:00:00 160 C 919864194270
4843 IC 03/07/2023 09:52:52 00:00:00 100 C 918210082975
4844 IC 03/07/2023 09:52:52 00:00:00 555 555 100 C 918210082975
4845 IC 03/07/2023 09:52:59 00:00:00 131 C 918210082975
4846 IC 03/07/2023 09:52:59 00:00:00 555 555 131 C 918210082975
4847 IC 03/07/2023 09:52:03 00:01:12 556 556 130 918700407523
4848 IC 03/07/2023 09:53:05 00:00:00 160 C 918210082975
4849 IC 03/07/2023 09:53:06 00:00:00 555 555 160 C 918210082975
4850 IC 03/07/2023 09:53:27 00:00:00 100 C 918210082975
4851 IC 03/07/2023 09:53:28 00:00:00 555 555 100 C 918210082975
4852 IC 03/07/2023 09:53:38 00:00:00 130 C 919864194270
4853 IC 03/07/2023 09:53:38 00:00:00 555 555 130 C 919864194270
4854 IC 03/07/2023 09:53:42 00:00:00 160 C 917417148385
4855 IC 03/07/2023 09:53:42 00:00:00 555 555 160 C 917417148385
4856 IC 03/07/2023 09:53:50 00:00:00 100 C 917417148385
4857 IC 03/07/2023 09:53:50 00:00:00 555 555 100 C 917417148385
4858 IC 03/07/2023 09:54:08 00:00:00 130 C 917417148385
4859 IC 03/07/2023 09:54:08 00:00:00 555 555 130 C 917417148385
Page No: 2 Indian Oil 4/7/2023,Tuesday
Filter Info: Date = 03/07/2023
Cnt. CT Date Start Duration Ext. Ext. Line Info Called Number Pul. Charge
No Time Starting Ending
____ ____ __________ ________ ________ ________ ________ ________ _______ ________________ ____ ________
4860 IC 03/07/2023 09:55:46 00:00:00 100 C 917417148385
4861 IC 03/07/2023 09:55:46 00:00:00 556 556 100 C 917417148385
4862 IC 03/07/2023 09:57:56 00:00:00 130 C 917979916997
4863 IC 03/07/2023 09:57:57 00:00:00 555 555 130 C 917979916997
4864 IC 03/07/2023 09:55:33 00:03:29 556 556 160 919864194270
4865 IC 03/07/2023 09:59:14 00:00:00 100 C 919957975045
4866 IC 03/07/2023 09:59:15 00:00:00 555 555 100 C 919957975045
4867 IC 03/07/2023 09:59:25 00:00:00 130 C 919957975045
4868 IC 03/07/2023 09:59:25 00:00:00 555 555 130 C 919957975045
4869 IC 03/07/2023 09:59:35 00:00:00 161 C 919957975045
4870 IC 03/07/2023 09:59:35 00:00:00 555 555 161 C 919957975045
4871 IC 03/07/2023 09:59:46 00:00:00 100 C 919957975045
4872 IC 03/07/2023 09:59:46 00:00:00 555 555 100 C 919957975045
4873 IC 03/07/2023 09:59:55 00:00:00 130 C 9427316695
4874 IC 03/07/2023 09:59:55 00:00:00 555 555 130 C 9427316695
4875 IC 03/07/2023 10:00:06 00:00:01 161 C 919957975045
4876 IC 03/07/2023 10:00:06 00:00:00 555 555 161 C 919957975045
4877 IC 03/07/2023 10:00:14 00:00:00 100 C 919957975045
4878 IC 03/07/2023 10:00:14 00:00:00 555 555 100 C 919957975045
4879 IC 03/07/2023 09:59:10 00:01:16 555 555 160 918750878442
4880 IC 03/07/2023 10:00:37 00:00:00 130 C 919957975045
4881 IC 03/07/2023 10:00:37 00:00:00 555 555 130 C 919957975045
4882 IC 03/07/2023 10:00:51 00:00:00 160 C 919957975045
4883 IC 03/07/2023 10:00:52 00:00:00 555 555 160 C 919957975045
4884 IC 03/07/2023 10:01:10 00:00:00 100 C 919957975045
4885 IC 03/07/2023 10:01:10 00:00:00 555 555 100 C 919957975045
4886 IC 03/07/2023 10:02:11 00:00:00 160 C 917417148385
4887 IC 03/07/2023 10:02:11 00:00:00 555 555 160 C 917417148385
4888 IC 03/07/2023 10:02:35 00:00:00 100 C 02221028078
4889 IC 03/07/2023 10:02:35 00:00:00 555 555 100 C 02221028078
4890 IC 03/07/2023 10:02:46 00:00:00 131 C 917297980688
4891 IC 03/07/2023 10:02:46 00:00:00 555 555 131 C 917297980688
4892 IC 03/07/2023 10:02:47 00:00:00 160 C 919818213662
4893 IC 03/07/2023 10:02:47 00:00:00 555 555 160 C 919818213662
4894 IC 03/07/2023 10:02:50 00:00:00 100 C 02221028078
4895 IC 03/07/2023 10:02:51 00:00:00 555 555 100 C 02221028078
4896 IC 03/07/2023 10:03:02 00:00:00 131 C 917297980688
4897 IC 03/07/2023 10:03:02 00:00:00 556 556 131 C 917297980688
4898 IC 03/07/2023 10:03:09 00:00:00 100 C 917297980688
4899 IC 03/07/2023 10:03:10 00:00:00 555 555 100 C 917297980688
4900 IC 03/07/2023 10:03:25 00:00:00 131 C 919711424878
4901 IC 03/07/2023 10:03:25 00:00:00 555 555 131 C 919711424878
4902 IC 03/07/2023 10:03:31 00:00:00 161 C 9711424878
4903 IC 03/07/2023 10:03:31 00:00:00 555 555 161 C 9711424878
4904 IC 03/07/2023 10:03:32 00:00:00 100 C 919999916126
4905 IC 03/07/2023 10:03:32 00:00:00 555 555 100 C 919999916126
4906 IC 03/07/2023 10:03:40 00:00:00 131 C 919999916126
4907 IC 03/07/2023 10:03:40 00:00:00 555 555 131 C 919999916126
4908 IC 03/07/2023 10:03:43 00:00:00 161 C 917297980688
4909 IC 03/07/2023 10:03:43 00:00:00 555 555 161 C 917297980688
4910 IC 03/07/2023 10:03:44 00:00:00 100 C 919999916126
4911 IC 03/07/2023 10:03:45 00:00:00 555 555 100 C 919999916126
4912 IC 03/07/2023 10:03:49 00:00:00 131 C 919999916126
4913 IC 03/07/2023 10:03:49 00:00:00 555 555 131 C 919999916126
4914 IC 03/07/2023 10:03:54 00:00:00 161 C 919999916126
4915 IC 03/07/2023 10:03:54 00:00:00 555 555 161 C 919999916126
4916 IC 03/07/2023 10:03:59 00:00:00 100 C 918769645157
4917 IC 03/07/2023 10:03:59 00:00:00 555 555 100 C 918769645157
4918 IC 03/07/2023 10:04:00 00:00:00 131 C 919999916126
4919 IC 03/07/2023 10:04:00 00:00:00 555 555 131 C 919999916126
4920 IC 03/07/2023 10:04:07 00:00:00 161 C 919999916126
4921 IC 03/07/2023 10:04:07 00:00:00 555 555 161 C 919999916126
4922 IC 03/07/2023 10:04:09 00:00:00 100 C 917297980688
4923 IC 03/07/2023 10:04:09 00:00:00 555 555 100 C 917297980688
4924 IC 03/07/2023 10:03:16 00:01:06 555 555 160 02221028078
4925 IC 03/07/2023 10:04:13 00:00:00 131 C 919999916126
4926 IC 03/07/2023 10:04:13 00:00:00 555 555 131 C 919999916126
4927 IC 03/07/2023 10:04:18 00:00:00 160 C 917297980688
4928 IC 03/07/2023 10:04:18 00:00:00 555 555 160 C 917297980688
4929 IC 03/07/2023 10:04:21 00:00:00 100 C 919999916126
4930 IC 03/07/2023 10:04:21 00:00:00 555 555 100 C 919999916126
4931 IC 03/07/2023 10:04:24 00:00:00 131 C 917297980688
Page No: 3 Indian Oil 4/7/2023,Tuesday
Filter Info: Date = 03/07/2023
Cnt. CT Date Start Duration Ext. Ext. Line Info Called Number Pul. Charge
No Time Starting Ending
____ ____ __________ ________ ________ ________ ________ ________ _______ ________________ ____ ________
4932 IC 03/07/2023 10:04:25 00:00:00 555 555 131 C 917297980688
4933 IC 03/07/2023 10:04:26 00:00:00 160 C 919999916126
4934 IC 03/07/2023 10:04:27 00:00:00 555 555 160 C 919999916126
4935 IC 03/07/2023 10:04:30 00:00:00 100 C 918769645157
4936 IC 03/07/2023 10:04:32 00:00:00 131 C 919999916126
4937 IC 03/07/2023 10:04:32 00:00:00 555 555 131 C 919999916126
4938 IC 03/07/2023 10:04:37 00:00:00 160 C 919999916126
4939 IC 03/07/2023 10:04:37 00:00:00 555 555 160 C 919999916126
4940 IC 03/07/2023 10:04:50 00:00:00 100 C 917297980688
4941 IC 03/07/2023 10:04:50 00:00:00 555 555 100 C 917297980688
4942 IC 03/07/2023 10:04:59 00:00:00 131 C 917297980688
4943 IC 03/07/2023 10:04:59 00:00:00 555 555 131 C 917297980688
4944 IC 03/07/2023 10:01:30 00:03:40 556 556 130 919957975045
4945 IC 03/07/2023 10:05:49 00:00:00 160 C 919818272011
4946 IC 03/07/2023 10:05:49 00:00:00 555 555 160 C 919818272011
4947 IC 03/07/2023 10:06:02 00:00:00 100 C 919818272011
4948 IC 03/07/2023 10:06:02 00:00:00 555 555 100 C 919818272011
4949 IC 03/07/2023 10:06:54 00:01:05 555 555 130 917297980688
4950 IC 03/07/2023 10:08:28 00:01:56 555 555 100 918879299060
4951 IC 03/07/2023 10:10:14 00:00:00 161 C 07046693319
4952 IC 03/07/2023 10:10:14 00:00:00 555 555 161 C 07046693319
4953 IC 03/07/2023 10:08:01 00:03:49 556 556 160 919818272011
4954 IC 03/07/2023 10:10:31 00:01:48 555 555 100 07046693319
4955 IC 03/07/2023 10:09:55 00:03:59 551 551 130 917417148385
4956 IC 03/07/2023 10:14:45 00:00:00 130 C 918005720231
4957 IC 03/07/2023 10:14:45 00:00:00 555 555 130 C 918005720231
4958 IC 03/07/2023 10:15:00 00:00:00 160 C 918005720231
4959 IC 03/07/2023 10:15:01 00:00:00 556 556 160 C 918005720231
4960 IC 03/07/2023 10:15:08 00:00:00 100 C 918005720231
4961 IC 03/07/2023 10:15:08 00:00:00 556 556 100 C 918005720231
4962 IC 03/07/2023 10:15:15 00:00:00 130 C 918005720231
4963 IC 03/07/2023 10:15:15 00:00:00 556 556 130 C 918005720231
4964 IC 03/07/2023 10:15:22 00:00:00 160 C 918005720231
4965 IC 03/07/2023 10:15:22 00:00:00 556 556 160 C 918005720231
4966 IC 03/07/2023 10:15:29 00:00:00 100 C 918005720231
4967 IC 03/07/2023 10:15:29 00:00:00 556 556 100 C 918005720231
4968 IC 03/07/2023 10:15:29 00:00:00 130 C 919878777707
4969 IC 03/07/2023 10:15:29 00:00:00 556 556 130 C 919878777707
4970 IC 03/07/2023 10:15:33 00:00:00 160 C 919878777707
4971 IC 03/07/2023 10:15:33 00:00:00 556 556 160 C 919878777707
4972 IC 03/07/2023 10:15:36 00:00:00 100 C 918005720231
4973 IC 03/07/2023 10:15:36 00:00:00 556 556 100 C 918005720231
4974 IC 03/07/2023 10:15:37 00:00:00 130 C 919878777707
4975 IC 03/07/2023 10:15:37 00:00:00 556 556 130 C 919878777707
4976 IC 03/07/2023 10:15:41 00:00:00 160 C 919878777707
4977 IC 03/07/2023 10:15:41 00:00:00 556 556 160 C 919878777707
4978 IC 03/07/2023 10:15:42 00:00:00 100 C 918005720231
4979 IC 03/07/2023 10:15:42 00:00:00 556 556 100 C 918005720231
4980 IC 03/07/2023 10:15:49 00:00:00 130 C 918005720231
4981 IC 03/07/2023 10:15:49 00:00:00 556 556 130 C 918005720231
4982 IC 03/07/2023 10:15:52 00:00:00 160 C 919878777707
4983 IC 03/07/2023 10:15:52 00:00:00 556 556 160 C 919878777707
4984 IC 03/07/2023 10:15:56 00:00:00 100 C 918005720231
4985 IC 03/07/2023 10:15:56 00:00:00 556 556 100 C 918005720231
4986 IC 03/07/2023 10:15:58 00:00:00 130 C 919878777707
4987 IC 03/07/2023 10:15:58 00:00:00 556 556 130 C 919878777707
4988 IC 03/07/2023 10:16:02 00:00:00 160 C 918005720231
4989 IC 03/07/2023 10:16:02 00:00:00 556 556 160 C 918005720231
4990 IC 03/07/2023 10:16:04 00:00:00 100 C 919878777707
4991 IC 03/07/2023 10:16:04 00:00:00 556 556 100 C 919878777707
4992 IC 03/07/2023 10:16:18 00:00:00 130 C 918005720231
4993 IC 03/07/2023 10:16:19 00:00:00 556 556 130 C 918005720231
4994 IC 03/07/2023 10:16:27 00:00:00 160 C 918005720231
4995 IC 03/07/2023 10:16:27 00:00:00 556 556 160 C 918005720231
4996 IC 03/07/2023 10:16:33 00:00:00 100 C 918005720231
4997 IC 03/07/2023 10:16:33 00:00:00 556 556 100 C 918005720231
4998 IC 03/07/2023 10:16:40 00:00:00 130 C 918005720231
4999 IC 03/07/2023 10:16:40 00:00:00 556 556 130 C 918005720231
5000 IC 03/07/2023 10:16:45 00:00:00 160 C 919878777707
5001 IC 03/07/2023 10:16:45 00:00:00 556 556 160 C 919878777707
5002 IC 03/07/2023 10:16:47 00:00:00 100 C 918005720231
5003 IC 03/07/2023 10:16:47 00:00:00 556 556 100 C 918005720231

[Anonymous]

Check your Transform Sanple File--I bet your example PDF has only one page. If that's your problem, then copy and rename that file to something like 111aaa so it's first in the folder. Power query will then probably pick that as the sample file and import all your stuff.

--Nate

[KuntalSingh]

Hi 

Folder have have date wise PDF file and each PDF have upto 100 page but page numbers are not not fixed it vaties PDF to PDF. It depends on number of calls Income and Outgoing.

[pratyashasamal]

Hi @KuntalSingh ,
You can follow this link to import data from PDF into Power BI :-
https://www.mssqltips.com/sqlservertip/5845/read-and-import-data-from-pdf-files-using-power-bi/#:~:t....

Note :- Once this connector processes the file, you would find a navigator screen where you can select all the pages that you need and then load the files. These pages will be loaded as separate table and you can merge them togther in powerquery.
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C

[KuntalSingh]

So sorry. I have already gone through this video and it won't help as it is for selected table but I need to all the pages from pdf from a folder and we not sure about number of pages in pdf file.

Thanks for your efforts!!

[KuntalSingh]

This solution is static not dynamic. I need to import all the pages from pdf and from a folder. Also I need solution in excel query editior not in Powe BI

[pratyashasamal]

Hi @KuntalSingh ,
Please follow this link :-
https://www.excelcampus.com/powerquery/import-pdf-excel/
Hope this was helpful.
Thanks,
Pratyasha Samal
Has this post solved your problem? Please Accept as Solution so that others can find it quickly and to let the community know your problem has been solved.
If you found this post helpful, please give Kudos C