Forum Discussion
Importing Credit card statement to power query in PDF format
Thank you so much for your help. As I'm not PBI savy at all, I'm using excel power query to get the data from the folder, I don't believe this will make any difference. Having said that, how do I get the equivalent of your screen shot, where you are showing Source name and transform file listing the tables? The 1st screen shot.
Thanks again,
Eqa
Hi Eqa ,
Select to Combine & Transform Data.
Click OK.
And then we'll get to those. We'll then use that as a basis for modification.
I have uploaded an Excel file containing the steps for your reference.
Best Regards,
Gao
Community Support Team
If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!
How to get your questions answered quickly -- How to provide sample data in the Power BI Forum
Here is a screenshot showing that my info is much messier than yours. Can I clean this up?