DAX
Data Analysis Expressions (DAX) is a library of functions and operators that can be combined to build formulas and expressions in Power BI, Analysis
... [Show More] Services, and Power Pivot in Excel data models.
Star Schema
n computing, the star schema is the simplest style of data mart schema and is the approach most widely used to develop data warehouses and dimensional data marts. The star schema consists of one or more fact tables referencing any number of dimension tables
Static Row Level Security
uses a fixed value in the DAX filter, while the dynamic method uses a DAX function.
In Power BI select Modeling tab, then Manage Roles. Create a role for each department and then add a DAX expression to it. For instance, you can create a role called Game and then add the DAX expression [department] = "Game". Then, whenever a member of that role interacts with the report, Power BI will add that filter to their interactions, thus limiting what they see.
Test Roles in Power BI
selecting the Modeling tab and then selecting View as Roles. In the View as roles window, select the Game role. The report now renders as if you were in that role, and you will only see the records that are included in the Game department.
Deploy Roles in Power BI
selecting the Publish button on the Home tab and then selecting a workspace.
Add members to the role
go to your workspace in Power BI service. Find the dataset that you created with the same name as your report. Select the ellipsis (...) button and then select Security.
add Microsoft Azure Active Directory (Azure AD) users and security groups to the security role. When members are added to this role, the DAX filter that you previously defined will be applied to them. If members are not added to the role, but they have access to the report, RLS will not apply to them.
Test the roles
selecting the ellipsis (...) next to the Game role on the Row-Level Security screen and then selecting Test as role.
Dynamic Row Level Security
set up row-level security only once, without the need to continue maintaining it dynamically.
EX. only show sales to the person who made them.
Notice that instead of the fixed string, such as Game or Clothing, this uses a DAX function in the row-level security filter.
userprincipalname() function will compare the email address from the Employees table with the email that the user entered when signing in to Power BI service.
workspace
centralized repository in which you can collaborate with colleagues and teams to create collections of reports and dashboards.
Create a workspace
Go to Power BI service.
Select the Workspaces drop-down menu.
Select the Create a workspace button at the bottom of the resulting panel.
Create a workspace window, enter information in the Workspace name and Description fields and then upload a Workspace image.
Advanced drop-down menu, you can create a Contact list of users who will receive notifications if issues with the workspace occur.
After you have filled out pertinent fields on the Create a workspace window, select Save.
Workspace 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
Workspace Member
Can complete all tasks that are associated with admins but can't add or remove users
Cannot delete the workspace
Cannot update the metadata about the workspace
Workspace Contributor
Cannot 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
Workspace Viewer
Cannot add or remove users
Can only view a report or dashboard in a workspace
Can read data that is stored in workspace dataflows
Create and configure an app
An app is a published, read-only window into your data for mass distribution and viewing. When ready to share apps with your users, you can publish the app. This process requires a Power BI Pro license. Consuming and viewing an app requires a Pro license or it must be backed by a Premium capacity.
Deployment pipeline (Premium)
manages content in dashboards, reports, and datasets between different environments in the development life cycle. With this feature, you can develop and test Power BI content in one centralized location and streamline the process before deploying the final content to your users.
Configuration of deployment pipelines
On the ribbon on the left side of the page, select Deployment pipelines, as shown in the following screenshot.
On the resulting page, select Create a pipeline.
Create a deployment pipeline called SalesPipeline. Enter the Pipeline name as SalesPipeline and enter a description, if necessary.
Select Create, which will take you to the following screen.
To create your pipeline, assign workspaces to each of these stages to facilitate where your reports and dashboards will be housed during each stage.
Select Assign a workspace to begin.
You will be directed to the Assign the workspace to a deployment stage window, where you can add the Tailwind Traders workspace to the Development environment.
If you already have Development, Test, and Production workspaces, choose one that you want to work with and then select Assign.
To view all objects that constitute the workspace, select Show more.
Data Lineage
path that data takes from the data source to the destination.
Lineage View
Simplifies the troubleshooting process because you can see the path that the data takes from source to destination and determine pain points and bottlenecks.
Allows you to manage your workspaces and observe the impact of a single change in one dataset to reports and dashboards.
Saves time by simplifying your task of identifying reports and dashboards that haven't been refreshed.
Only available for App Workspaces
Analysis services instance
Can install Multidimensional or Tabular model in an Analysis services instance. Can use DAX or MDX for querying data in either model.
Multidimensional Model
MDX (business logic) [Show Less]