Get data from multiple sources!

Power BI supports large range of data sources.

You can click Get data and it shows you all the available data connections. 
It allows you to connect to different flat files, SQL database, and Azure cloud or even web platforms such as Facebook, Google Analytics, and Salesforce objects.

    In this article, I will be importing various film tables and create an film report. The data to be imported includes two CSV file and one Excel file.

Let's get started...

    Create a Power BI report by loading data from Excel and CSV file using Get Data connection.

    

    Once the data is loaded, lets move to Model view to manage the relationship between the three tables.

    The three tables are Genres, Films and Director. Within which Films table is the master table here.

    Now, to represent well let's rename the fields in field pane by right clicking the column.

        

    Going to report view, let's create three table visual :

1. Listing out Directors
2. Listing out Genres
3. List out the films made by Director with Genres.

    So, first table will include Director and Gender as values.

    As formatting part, title is added to this table as Directors and background color is given for it as well using Format pane.

    Second table includes all genres as the value. And title is also added to this table as Genres using Format pane with background color.

    Third and last table includes all the Director name from Director table, Genres from Genre table and Title from Films table.

By selecting Akira Kurosawa from Director table, all the films directed by this particular director with its respective genres were listed.

Saving the report as Go Akira.pbix , sounds fun!!! 😀