Deploy & Maintain Assets Flashcards
What is Power BI Gateway?
Software that has to be installed to use to get to resources that Power BI generally can’t connect to (on-premises network)
What can Power BI Gateway be used with?
Power BI Azure Analysis Services Power Apps Power Automate Azure Logic Apps
What are the 2 types of Power BI Gateway?
Standard Mode - allows connections with multiple on-premises data sources for more than one user
Personal Mode - on-premises data gateway is used by only one user to connect to different data sources
How does Power BI Function as it relate to cloud services?
It functions as a mediator between cloud services and on-premises data sources
How do you configure a dataset scheduled refresh?
under Datasets, select More options (…) next to a dataset listed.
Select Schedule refresh.
set/define the frequency and time slot to refresh the dataset.
What is row-level security?
Row-level security (RLS) with Power BI can be used to restrict data access for given users. Filters restrict data access at the row level, and you can define filters within roles.
What data models can row-level security be configured for?
You can configure RLS for data models imported into Power BI with Power BI Desktop. You can also configure RLS on datasets that are using DirectQuery, such as SQL Server.
Where is row-level security configured for live connections and Analysis Azure Services?
For Analysis Services or Azure Analysis Services lives connections, you configure Row-level security in the model, not in Power BI Desktop. The security option will not show up for live connection datasets.
Where are roles defined?
You can define roles and rules within Power BI Desktop. When you publish to Power BI, it also publishes the role definitions
What are the steps to defining roles?
Import data into your Power BI Desktop report, or configure a DirectQuery connection.
From the Modeling tab, select Manage Roles.
From the Manage roles window, select Create.
Under Roles, provide a name for the role. (You can’t define a role with a comma, for example London,ParisRole.)
Under Tables, select the table to which you want to apply a DAX rule.
In the Table filter DAX expression box, enter the DAX expressions. This expression returns a value of true or false. For example: [Entity ID] = “Value”.
After you’ve created the DAX expression, select the checkmark above the expression box to validate the expression
Select Save.
How do you validate a role you’ve defined?
From the Modeling tab, select View as.
The View as roles window appears, where you see the roles you’ve created.
Select a role you created, and then select OK to apply that role.
The report renders the data relevant for that role.
You can also select Other user and supply a given user.
It’s best to supply the User Principal Name (UPN) as that’s what the Power BI service and Power BI Report Server use.
Within Power BI Desktop, Other user displays different results only if you’re using dynamic security based on your DAX expressions.
Select OK.
The report renders based on what that user can see.
What option in Power BI service will allow you to add users to roles you created in Power BI desktop?
Security will take you to the Role-Level Security page where you add members to a role you created in Power BI Desktop.
Only the owners of the dataset will see Security. If the dataset is in a Group, only administrators of the group will see the security option.
How do you add members to the role in Power BI service?
In the Power BI service, select the More options menu for a dataset. This menu appears when you hover on a dataset name, whether you select it from the navigation menu or the workspace page.
Select Security.
you can add a member to the role by typing in the email address or name of the user or security group. You can’t add Groups created in Power BI. You can add members external to your organization.
What groups can you use set up row level security?
Distribution Group
Mail-enabled Group
Security Group
What’s a Mail-enabled security group?
Mail-enabled security groups are used for granting access to resources such as SharePoint, and emailing notifications to those users.
What are Distribution groups?
Distribution groups are used for sending email notifications to a group of people.
What are Security groups?
Security groups are used for granting access to resources such as SharePoint sites.
How do you grant access to datasets?
To open the dataset manage permissions page:
From the datasets hub: Select Manage permissions on the More options (…) menu.
or
From the dataset info page: Select the Share icon on the action bar at the top of the page and choose Manage permissions
To modify a user’s permissions, select More options (…) and choose one of the available options.
To grant dataset access to another user, click + Add user. The Share dataset dialog will open.
What are Global options in Power BI?
Global options are applied to all Power BI Desktop files created or accessed by the user
How do you create a workspace in Power BI
In Power Bi Service, Select Workspaces > Create workspace.
Give the workspace a unique name. If the name isn’t available, edit it to come up with a name that’s unique.
What is the default name of an app created from a workspace?
When you create an app from the workspace, by default it will have the same name and icon as the workspace. You can change both when you create the app.
What setting options are available in your created workspace?
Upload a Workspace image. Files can be .png or .jpg format. File size has to be less than 45 KB.
Specify a Workspace OneDrive to use a Microsoft 365 Group file storage location (provided by SharePoint).
Add a Contact list, the names of people to contact for information about the workspace. By default, the workspace admins are the contacts.
Allow contributors to update the app for the workspace
Assign the workspace to a Premium capacity.
Connect the workspace to an Azure Data Lake Gen2 storage account (in preview). Read about this functionality in the article Configuring dataflow storage to use Azure Data Lake Gen 2.
How do you give access to your workspace?
Because you have the Admin role in the workspace, on the workspace content list page, you see Access.
Add security groups, distribution lists, Microsoft 365 groups, or individuals to these workspaces as admins, members, contributors, or viewers.
Select Add > Close.
How do you assign appropriate workspace roles to users?
· UseContributorrole only fordevelopers
· UseMemberrole fordeployment groups
· UseAdminrole for theworkspace admins
· UseViewerrole forbusiness users/end users
