Connecting Microsoft PowerBI to MySql Database – Working on Sakila Database
Let’s explore connectivity of Power BI with 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: