Refresh Cube using PowerShell

PowerShell (Option 2)

Scheduling a Full Tabular Model Refresh

1. Setup the service account with privileges to run cube processing (AD, SSAS privileges).
2. Make the automation accounts.

3. Go to PROCESS AUTOMATION > Runbooks.

4. Add new runbook.

5. Add all needed information like runbook name, type, description…

6. Enter powershell code for cube processing .

• Click on Save.
• Click on Publish.

7. Adding schedule.

8. Configure new schedule.

Once when filled with all information, and created schedule will trigger runbook. Runbook will start powershell script.

Scheduling a Partial Tabular Model Refresh

Section Pending

Scheduling a Partition based Refresh

Section Pending

Tabular Security

Setting up Mail-enabled Security Groups

*You will need to be an Azure Administrator or at least have assistance from an Azure Administrator to complete the following steps.

1. Log into portal.azure.com.
2. If “Groups” is not already listed under your favorites, click on All services, scroll down to the “Identity” section and select “Groups.”.
3. Click “New group”.

4. Select “Office 365” under “Group type”.
5. Give your group a name and select “Assigned” under “Membership type”.

6. Search for the members that you wish to add to the group and click select.
7. Be sure to add group owners by clicking “Add owners”.
   1. The users who are added as owners will be able to manage membership of the security group.
8. Users who are added to the groups should now have access to the Power BI resources assigned to that group.

Applying Mail enabled security groups to Roles

Roles are used in Analysis Services to manage model data access.
A group or user can be a member of any number of roles, each role with a different permission. When a user is a member of multiple roles, the permissions defined for each role are cumulative.

A group or user can be a member of any number of roles, each role with a different permission. When a user is a member of multiple roles, the permissions defined for each role are cumulative.

Each role can have one the following permissions defined:

• None
• Read
• Read and Process
• Process
• Administrator
  

To create a Role, open Role Manager –

In the Role Manager Dialog Box, click create a New Role. In the Permissions field, click the down arrow and then select permission type.

If the role you are creating has Read or Read and Process permission, you can add row filters using a DAX formula. To add row filters, click the Row Filters tab, then select a table, then click the DAX Filter field, and then type a DAX formula.

Applying Record Level Security