DEV Community

Tumusiime Kipruto
Tumusiime Kipruto

Posted on

A Comprehensive Guide to Connecting Power BI to SQL Databases.

If you agree with me, once you open a large spreadsheet full of row's and columns of unending data. Many at times we fail to interpret the data or even fail to understand what the data is actually telling us. Now this is where the saviour's in the I.T world come in handy. Actually cheers to the mighty brains that are behind this very tools that have made the work of data scientists and analysts extremely enjoyable.

Now at this point you're probably wondering what i'm even talking abt so this are the tools;
-Power BI Desktop.

  • Power BI Service.
  • Power Query.
  • Power Pivot.
  • Excel Power Query. -Excel Power Pivot.

now all this tools stated above are the saviour's im talking about but unfortunately today ill be dwelling majorly on Power BI.

Power BI.

Now Power BI is a business intelligence tool that connects to SQL databases such as PostgreSQL, Microsoft SQL Server, MySQL, and Oracle to analyze and visualize data. Using Power Query, data can be extracted, cleaned, and transformed before creating interactive reports and dashboards that support informed decision-making.

Today ill take you through the process of connecting your local database to your postgres SQL database.

Step 1

  1. Open your local database that is installed in your computer, laptop orr in rare case mobile phone.

  2. Open any browser in your machine search for aiven choose thee postgres SQL service and make sure its running.

  3. In your local database what i majorly advice is you just hold _ctrl+shift+N_ thus is easier and just gives you what you need instead of going through a lot. Now after pressing that a pop-up appears containing all the cloud managed databases available in that local database.

  4. After choosing the service you want to use, go back to your aiven account by this time it is running and pick the credentials provided by that service database this is;

  • URL.
  • host. -password. -database.
  • username.
  • Authentication. after successfully transferring the above information to your local database before finishing the process its always a good practice to first test connection then after Finish

Top comments (0)