Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Djordje_M

Connecting your data source to Power BI – About the third-party sources and PDFs

The data source is the path to the information you want to work with. It can be a path to the local file, the URL to Facebook, or the database's location in the Cloud. A data set is a collection of the data source and the data itself. Power Bi offers a range of data source types and many platforms from which you can get data.

 

The Files the Power BI Desktop offers tare: Excel, CSV, XML, Text, JSON, PDF, etc. It can also connect to all known databases, kept locally or on Cloud. Also, you can get data from the WEB using any third-party service, like Windsor.ai.

 

In Power BI Services (WEB), you can use Power App connectors published by the third party publisher. Windsor.ai also has a number of those connectors if that is thy way you want to use the platform.

 

How to connect to a third-party data source

 

You can import data from all major databases and services into Power BI using various file formats.  Using third-party data sources like can look like in this Media Overview Report dashboard template that fetches all of your advertising data, including Facebook, and then visualizes it in a single view.

 

This Web Multichannel Attribution dashboard helps you to integrate all your performance marketing data into one place. By default, it connects to your analytics data set (Google Analytics) and connects them with your media data.

Getting data into Power BI is easy once you have completed the registration process. Once it's all connected, you can understand how many clicks, impressions, and spendings you have on each channel and of each touchpoint in your customer journeys.

 

How to convert data from PDF

 

It is often useful to get some data available only in PDF files. Those are mainly external reports, published for advertising or informational purposes, widely available on the web.

Using Power Query Power BI (or Excel), we can extract tables or entire pages of information from PDF files.

 

We can use Power Query to extract information from PDF files like described here:

 

  • In Power BI Desktop use Get Data and then select the desired format.

 

Djordje_M_0-1603004704287.jpeg

 

  • Select the PDF  file from the selection.
  • You will see in preview tables and pages available in the PDF file.
  • Select the table or page and click Load or Transform Data if you need to clean and/or modify them to fit your output needs, and then select Close & Load.

 

Djordje_M_1-1603004704296.png

 

  • If the PDF needs to be updated, you need to right-click on the extracted table and select Refresh to receive the updated information.

 

Transforming the data

 

Using standard Power Query transformation tools (like Merge Columns, Trim Text, Rename Columns, Remove Blank Rows, etc.), we can quickly and easily customize the table.

With the entire PDF file brought into the Power Query Editor, we can perform a series of transformations like Filter for tables, remove unneeded columns, combine (append) the tables into a single table, rename the columns, set data types, and more…

 

Conclusion

 

Tools you use to keep track of your advertising campaigns are essential for you to decide on the next steps in your Customer acquirement and retention. But, always keep in mind that your insights and continued involvement are necessary to get to the top. Choosing the right tool will help you a lot, but you have the final word, as always.

It would be beneficial to know what are the most used data sources for Power BI reports. Apart from your own data from various local or Cloud databases, do you use a third party or web source? Do you find importing data from PDFs useful? Let me know about your experiences.

 

Further steps

 

It is just the beginning of my Power BI reports journey. I have used different data sources to create my reports. I have published them in Power BI Data Stories Gallery, and I invite you to check them out. Please let me know if this article was clear enough and provided you with the information you need to connect to your data using a third-party vendor template. I will be happy to update this article with the necessary details. Also, you can find more information on my blog.