Download for Free

Click on the link below to download Power BI Desktop latest version for free from Microsoft website.

url

Basics & Best Practices

Three Core Views

Report, Data & Relationships
Read More

Data View

Table & Column Tools
Read More

Query Editing Tools

Home, Transform & Column tab
Read More

Efficient Approach

Options to deselect & to exclude in report refresh
Read More

Avoid Ambiguous Relationship

Ambiguous Relationship means when multiiple two-way filters are in use. For instance when a Table has more than one lookup table connected to it, it creates ambiguous relationship
Read More

This is the heading

Lorem ipsum dolor sit amet consectetur adipiscing elit dolor
Read More

Three Core Views

Report

This View is used lastly to design interactive reports and visualizations.

Data

Start with this view first where you Connect, shape and transform raw data.

Relationships

After Data view, switch to Relationships view to design data model and tie those tables together with relationships.

Data View

Table Tools

Click on any given Table under Fields to access attributes related to the Table, modify Columns, Manage Relationships, add Columns  and much more.

 

Column Tools

Click on any given Column under the Table to access attributes related to the Column and much more. Similarly select Measure to view Measure tools menu.

Query Editing Tool

Home Tab

This section includes general settings and commonly used table transformation tools.

Transform Tab

This section includes tools to modify existing columns. When tool is selected from the Transform Tab, selected Column essentially gets modified or overwritten without any new Column created in the Table.

Add Colum Tab

This section is used to create Columns based on rules, operations, dates and much more. When a tool is selected from Add Column Tab, new column is created in the Table.

Efficient Approach

Faster Data Refresh

Deselect static data Table from report refresh for. e.g. Table that consists of values that do not change.

Structured Approach

01. Give the name to the Table in relation to the unique value it holds for lookup.

02. Check Column Header Data type.

Share This:

Blogs

© Project Insights. All Rights Reserved.