Tuesday, 27 July 2021

How to create Roles in AAS

 How to create Roles in AAS – Sh 

 

In Object Exporer, right-click Roles > New Role. 

In Create Role, enter a role name and description. 

Select a permission. 

TABLE 2 

Permission 

Description 

Full control (Administrator) 

Members can modify the model schema, process, and can query all data. 

Process database 

Members can run Process and Process All operations. Cannot modify the model schema and cannot query data. 

Read 

Members can query data (based on row filters) but cannot modify the model schema. 

Click Membership, then enter a user or group in your tenant Azure AD by email address. 

Add user 

If the role you are creating has Read permission, you can add row filters by using a DAX formula. Click Row Filters, select a table, and then type a DAX formula in the DAX Filter field. 

 

Best practice to load data to Data warehouse, Datamart

 Best Practise to Load Data To dataMart 

https://www.youtube.com/watch?v=ZabXH-QSRsA 

 

Best Practise to Load data to Datawarehouse 

Tabular Azure Analysis services best practices

 Tabular Analysis Service Best Practice - Sh 

Power BI Best practise

 Power BI Best Practice - Sh 

Power BI – To check if two values in two columns is equal

 Power BI – To check if two values in two columns is equal 

 
Measure 3 = if(max(Ticket[Column2]) = max(FSales[Category2]), BLANK(), [Measure 2]) 

Power BI - the max function only accepts a column reference

 Power BI - the max function only accepts a column reference 

Check if you are entering a measure . We have to enter a column name actually while using this formula