Power BI

Power BI is a reporting tool. Using Power BI, you can create very insightful visualizations, which you can manipulate, you can publish, or you can also share them with your colleagues

 In Power BI, you can gather data from various sources to quickly create reports.

In direct query not all features are available like the DAX functions are not there

For smaller datasets go for import mode

See the applied steps below

Extract the required information like below

Understanding cardinality here

Building Blocks of Power BI

Visualizations -  

Visual representation of data. It may be a chart, it may be a color coded map

Datasets -  Collection of data that Power BI uses to create visualizations, it can be a combination of many sources

Reports - Report simply means a collection of visualization, that are arranged in such a way, so that they all are related to each other, and they can tell us the best story about our product or whatever we are creating report for

Dashboards - When you want to share your visualizations or maybe a collection of visualization, or maybe a report, then you create a dashboard. So dashboard basically is a place where you can share your visualization, maybe with your friends, with your colleagues or different users or groups. And these people can also interact with your dashboard.

Tiles - The rectangular boxes that holds an individual visual

Paginated Reports

• Designed to be printed or shared
• Called paginated because they are well formatted to fit in one page
• Major advantage - ability to print all the data in a table no matter how long
• Power BI report - lets you print what you see on the page
• Paginated report - Print many pages to include all the rows
• Preview the report in Report builder and then publish to the Power BI service, app.powerbi.com

Interactive Reports 

• User can interact with report
• Designed to view on the screen
• Provide the end users to do data manipulation, such as drilling through various levels of data, filtering and sorting 
• This is a premium version of Power BI. So Power BI require Power BI premium in order to use these kind of interactive reports