Power Query (which has been the go-to tool for importing data into Excel for some time now) has a new option! Rereiving data from PDF documents has been around for a long time, and now you can also pick up tables from an image or image on the clipboard. So, if someone sends you an invoice that they took a photo of via Viber or WhatsApp, you don’t have to enter the data manually.
Exporting a table to PDF is not a new feature, it has been around for ten years or more. But how to import a table from a PDF document into Excel? This task is performed by Power Query which, since the latest version, has become an integral part of Excel and you can’t bypass it, no matter what kind of data you import into the application. Since recently he has this fantastic option, let’s see how it is used …
In a previous post I talked about the history and gave brief introductory remarks regarding PowerBI service and its “tastes” (PowerBI, PowerBI Desktop, PowerBI Mobile). In the text that follows you will see how to apply on PowerBI service and import data from a desired source. We will connect to data table, taken from ERP solution, and connect to the data you will later use to create the report. Concentrate, the magic begins!