Connecting Microsoft PowerBI to MySql Database – Working on Sakila Database

Let’s explore connectivity of Power BI with MySQL Database.

MySQL Database:

Open Power BI and click on Get Data > More Options:

Select My SQL Database and connect to database:

Load MySQL Database table:

Select table and click on Load button:

Payment table is loaded into Power BI.

Load more tables from same Database:

Create Relationship between sakila_customer and sakila _ payment tables on the basis of identical field customer_id:

 

Create visualization from two tables:

This visualization is giving details about payment of different actors on the basis of first name and last update.

Create new visualization with same details:

Now we will create a Waterfall chart for increase and decrease in payment amount according to count of customer id and first name of actors:

Leave a Comment

Your email address will not be published. Required fields are marked *

Scroll to Top