1.    What are the data sources that Power BI can connect? 

Power BI offers connectivity to various data sources, categorized into three primary types:

Files:

·       It can import data from Excel (.xlsx, .xlxm), Power BI Desktop files (.pbix), and Comma-Separated Values (.csv).

Content Packs:

·       These packs consist of related documents or files grouped together. Two types of content packs are available in Power BI:

·       Content packs from service providers like Google Analytics, Marketo, or Salesforce.

·       Content packs created and shared by other users within your organization.

Connectors:

·      Connectors facilitate the linkage of databases and datasets with apps, services, and cloud-based data.

2.    Can you explain Power BI dashboard? 

A dashboard serves as a consolidated presentation sheet containing multiple visualization reports. Key attributes of Power BI dashboards include:

·       Enabling the ability to drill through the page, utilize bookmarks, and access the selection pane, while also facilitating the creation of various tiles and the integration of URLs.

·       Offering the option to set the report layout to a mobile view, ensuring adaptability across different devices.

3.    Describe the process of defining relationships in Power BI Desktop.? 

Table relationships in Power BI Desktop can be established in two ways:

·       Manual: Users define relationships between tables by specifying primary and foreign keys manually.

·      Automatic: This feature in Power BI, when enabled, automatically detects relationships between tables and creates them without manual intervention.

4.    Is it possible to establish multiple functional relationships between two tables in a Power Pivot data model?

It's not feasible to have more than one active relationship between two tables in a Power Pivot data model. While multiple inactive relationships can exist, only a single active relationship is allowed. In visual representation, dotted lines signify inactive relationships, whereas continuous lines denote active relationships.

5.    Is it possible to include a table in the model that is not joined with any other tables?

Disconnected tables are used to hold values for metrics and could be used as parameter values to be exposed and to be passed to slicer.

6.    Understanding CALCULATE Function in DAX?

The CALCULATE function is used for applying filter on expression.

CALCULATE(<expression>[, <filter1> [, <filter2> [, …]]])

Example:

Sum of sales amount for cars based on brands=

CALCULATE (

    Sum ( Sales[Sale Amount] ),

    'Product'[Car] = "Honda")

)

7.    Where is data stored in Power BI? 

Power BI employs two central repositories to store and oversee data.

1.     Azure SQL Database

2.     Azure Blob Storage

8.    What is row-level security?

Inorder to restrict data Power BI uses row-level security.

·       Create roles using manage role.

·       Click on table add filter.

·       save




9.    Explain Power BI Desktop views? 

Power BI provide three different views.

Report View – In this view developer selects different visualizations on tiles and section for report view development.

Data View - In this view, developer can change data format, shorting, grouping, add calculated columns, applying data filtering.

Model View - In this view, developer define join relationship between tables.

10. Primary versions of Power BI?

·       Power BI Desktop 

·       Power BI service

Mobile Power BI apps for iOS and Android devices

11. What is meant by a content pack?

A content pack is described as a pre-assembled assortment of visualizations and Power BI reports tailored to your selected service. Utilizing a content pack is advantageous when aiming for a swift start, rather than initiating the creation of a report from the ground up.

12.  What are major building blocks of Microsoft Power BI.

Power BI comprises essential components, namely dashboards, reports, workbooks, semantic models, dataflows, and apps.

Dashboards

A dashboard is crafted either by yourself in the Power BI service or by a colleague who shares it with you through the Power BI service. It serves as a unified canvas hosting various tiles and widgets. Each tile, sourced from a report or generated through Q&A, exhibits a singular visualization derived from a semantic model and affixed to the dashboard.

Reports

A Power BI report consists of one or more pages containing visualizations, such as line charts, maps, and treemaps. These visualizations, also known as visuals, originate from a unified semantic model within the report.

Tiles

A tile is a captured view of your data affixed to the dashboard. Tiles can be generated from a report, dashboard, the Q&A box, Excel, SQL Server Reporting Services (SSRS) reports, and other sources. 

Semantic models

A semantic model constitutes a compilation of data that can be either imported or connected to. Power BI facilitates the connection and importation of various semantic models, consolidating them into a unified space. Additionally, semantic models can derive data from dataflows.

Dataflow

A dataflow plays a crucial role in consolidating data from diverse sources within organizations. While optional, they prove particularly beneficial in complex or extensive projects. Essentially, dataflows represent data that has been processed and staged for utilization by semantic models. In Power BI Desktop, dataflows are presented with a dedicated connector, facilitating seamless reporting. Connecting to a dataflow allows your semantic model to leverage the previously prepared data and business logic, fostering a unified source of truth and promoting data reusability. Moreover, they leverage Microsoft Purview Data Connectors, enabling the ingestion of data from both on-premises and cloud-based sources.

Apps

An app comprises dashboards and reports meticulously crafted to provide essential metrics to Power BI consumers within your organization. While apps offer interactivity, consumers do not possess the capability to edit them. Colleagues designated as app consumers, who have access to these apps, may not require Pro or Premium Per User (PPU) licenses.

13. What are the key components of the Power BI?

The key components of Power BI are as follows.

·       Power Pivot

·       Power View

·       Power Query

·       Power Map

Power Q&A