LOADING

Type to search

Connecting Microsoft PowerBI to MySql Database – Working on Sakila Database

To Know more about the Different Corporate Training & Consulting Visit our website www.Instrovate.com Or Email : info@instrovate.com or WhatsApp / Call at +91 74289 52788

PowerBI

Connecting Microsoft PowerBI to MySql Database – Working on Sakila Database

Share

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:

Tags:

You Might also Like

Leave a Comment

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