Create and Manage Workspace in Power BI

Workspace


A workspace is a centralized location or repository that allows you to collaborate with colleagues and teams to create collections of reports, dashboards, and so on.

Workspaces are used to collaborate and share content with colleagues. We can add colleagues to our workspaces and collaborate on dashboards, reports, workbooks, and datasets.

Different roles in workspace

The abilities of role types in a workspace include:

  • Admin

    • Add/remove other users

    • Publish, update, and/or share an app in a workspace

    • Create, edit, delete, and publish reports and content in a workspace

    • View and interact with reports and dashboards in a workspace

    • Configure data refreshes

  • Member

    • Can complete all tasks that are associated with admins but can't add or remove users

    • Can not delete the workspace

    • Can not update the metadata about the workspace

  • Contributor

    • Can not add or remove users

    • Cannot publish, update, or edit an app in a workspace unless given this ability by admins/members

    • Can create, update, and publish content and reports within a workspace

    • Can schedule data refreshes

  • Viewer

    • Can not add or remove users

    • Can only view a report or dashboard in a workspace

    • Can read data that is stored in workspace dataflows


Monitor usage and performance

Usage metric reports are available for Power BI Pro users and can only be accessed by users with the role types of Admin, Member, or Contributor.
 
To view usage metric reports, go to the pertinent workspace. Find the report or dashboard that want to see usage metrics for


Deployment Pipeline

The advantages of using the deployment pipeline are:

  • Increased productivity - Through this feature, we can reuse previous deployment pipelines, ensuring that efforts aren't duplicated.

  • Faster delivery of content - Report development becomes more streamlined, meaning that it takes less time to get to production.

  • Lower human intervention required - Having the ability to reuse deployment pipelines means a decreased chance of error associated with moving content from one environment to another.


Lineage View

The Lineage view is only accessible to Admin, Contributor, and Member roles. Additionally, it requires a Power BI Pro license and is only available for app workspaces. To access the Lineage view, go to the workspace, and then select Lineage from the View drop-down menu on the top ribbon.

Conclusion

In this blog I have explored importance and usage of workspace, different roles in workspace usage performance, lineage view, deployment pipeline etc.

Comments

Post a Comment

Popular posts from this blog

Use DAX iterator functions in Power BI Desktop models

Data Analysis Expressions (DAX) include a set of functions known as  iterator functions . Iterator functions enumerate all rows of a given table and evaluate a given expression for each row. They provide you with flexibility and control over how your model calculations will summarize data. Some DAX Functions are Complex summarization 1. SUMX e.g. : 1.  Revenue = SUMX (Sales, Sales[Sales Amount]) 2. Revenue = SUMX (Sales, Sales[Order Quantity] * Sales[Unit Price] * ( 1 - Sales[Unit Price Discount Pct.])) 3. Discount = SUMX ( Sales, Sales[Order Quantity] *( RELATED ('Product'[List Price]) - Sales[Unit Price] ) ) 2. AVERAGEX e.g :1. Revenue Avg = AVERAGEX ( Sales, Sales[Order Quantity] * Sales[Unit Price] * ( 1 - Sales[Unit Price Discount Pct.]) ) 2. Revenue Avg Order = AVERAGEX ( VALUES ('Sales Order'[Sales Order]), [Revenue] ) 3. RANKX The  RANKX  DAX function is a special iterator function you can use to calculate ranks. Its syntax is as follows: RANKX (<...
Read more

Different charts in Power BI

Image
  An overview of Chart Types in Power BI As everyone might be aware, Power BI is one of the SaaS offerings from Microsoft in the field of BI and Analytics. It provides a very intuitive way for non-technical users to do analyses and create reports on their own without having to rely on a technical team. One of the main purposes of Microsoft behind Power BI is to promote self-service BI and it is one of the BI tools in the market with a comparatively lower learning curve as there are many similarities compared to Microsoft Excel.  In this blog, I am going to give an overview of the most widely used chart types in Power BI.   Let's look at some of the most frequently used chart types in Power BI Bar and column charts Stacked Bar and Stacked Column Chart Clustered Bar and Clustered Column Chart Line Chart Area Chart Stacked Area Chart Line and Stacked Column Chart/ Combo Chart Line and Clustered Column Chart/ Combo Chart Ribbon Chart Waterfall Chart Funnel Chart Scatter Chart...
Read more

Modify DAX filter context in Power BI Desktop models

Summary CALCULATE  DAX function to modify filter context in the formulas. The syntax for the CALCULATE function is as follows: CALCULATE (<expression>, [[<filter1>], <filter2>]…) I learned about filter context. And also learned why and how to work with the CALCULATE function to modify filter context by passing in filters. These filters can add or overwrite the filter context, and they can modify filter context when we are passing in special functions like REMOVEFILTERS or KEEPFILTERS. Additionally, I learned that the CALCULATE function can transition row context to filter context, which can be required when we are using measure expressions in calculated columns or iterator functions.
Read more