How to Refresh Azure Analysis Service Model using Azure Data Factory

How to Schedule and Refresh an Azure Analysis Service Model using Azure Data Factory
1) Add Azure Data Factory as Managed Identity to the Azure Analysis Service:
First go the Azure Portal > Azure Analysis Service > Access Control(IAM).
Next click on add new Role Assignment and then choose Role > Contributor
Next go to Members > Assign access to > and choose Managed Identity and then Select Members.
Next from Select Managed Identities > Select the Azure Data Factory as a Managed Identity.

Note:
Please make sure you have created a ADF Service first to use above.

2) Generate the ADF Service Principal as per below:
app:<Managed identity Application ID>@<Managed identity Tenant>

Notes :
The details of <Managed identity Application ID> ; <Managed Identity Tenant> can accessed from the Azure Portal > Azure Data Factory service > Properties

3) Add the ADF Service Preincipal as an User to Azure Azure Analysis Service Model from SQL Server Management Studio(SSMS):
Go the SSMS > AAS Server>Properties>Security.
Next add the "ADF Service Principal" as an User.

4) Generate the AAS URL to use in ADF Pipeline for Refresh:
The Azure AAS url link be like below, which will be using in the Next step in ADF Pipeline > Web activity.
https://<region>.asazure.windows.net/servers/<AAS ServerName>/models/<AAS ModelName>/refreshes

Eg: Azure AS Server Name:
asazure:/<region>.asazure.windows.net/<AAS ServerName>
asazure:/centralus.asazure.windows.net/AAStestService

Eg: Azure AS URL/Link to Refresh:
https://centralus.asazure.windows.net/servers/AAStestService/models/AAStestModel/

refreshes

5) Create a Pipeline in ADF to Refresh AAS Model:
First go to ADF > Create a new Pipeline.
Next choose the Web activity from the Pipeline > Activities > Web.
Next go to the Web > Settings > URL and pass the URL like below of your AAS Model to refresh.

https://<region>.asazure.windows.net/servers/<AAS ServerName>/models/<AAS ModelName>/refreshes

Next choose the Method as "POST" in the same Web>Settings window.
Next in the body use the below Json Script to Process the AAS Model:

To full process the entire Model:

{
"Type": "Full",
"CommitMode": "transactional",
"MaxParallelism": 2,
"RetryCount": 2,
"Objects": []
}

To full process specific Table/Partition of the Model:

{
"Type": "Full",
"CommitMode": "transactional",
"MaxParallelism": 2,
"RetryCount": 2,

"Objects": [
{
"table": "DimProduct",
"partition": "CurrentYear"
},

{
"table": "DimDepartment"
}
]

}

Next choose the Integration Runtime as "AutoResolveIntegrationRuntime".
Next choose the Authentication as "Managed Identity".

Next in the Resource, you can pass the below link:
https://*.asazure.windows.net

Finally Save and Excecute(Debug) to run the Web task and process the Cube.

Notes:
We can use the "GET" method and run the Pipeline to see the Model refresh status.

6) Finally, Add a Trigger and Schedule the ADF Pipeline for Automatically Refresh AAS Model:
Go to ADF > Pipeline > Triggers , then add a Trigger to run the Pipeline at a specified Schedule(Every Minute/Hour/Week/Month).

Finally Save and Publish the ADF Service.

What is Power BI Administration

What is Power BI Administration and its related Roles
The Power BI administration is a management of organization-wide settings that control how Power BI works. The users that are assigned to admin roles configure, monitor, and provision organizational resources. In this article, we discuss about an overview of administration roles, tasks, and tools.

Administrator roles related to Power BI :

There are several roles that work together to administer Power BI for your organization. Most of the admin roles are assigned in the Microsoft 365 admin center or by using PowerShell. The Power BI Premium Capacity and Power BI Embedded Capacity admin roles are assigned when the capacity is created. 

Administrative tasks and tools :

Power BI admins work mostly in the Power BI admin portal. You should, however, be familiar with related tools and admin centers. Look at the table above to determine which role is required to do tasks using the tools listed here.

Assigning the admin roles :

If you are the person who purchased your Microsoft business subscription, you are the global admin. Which means you have unlimited control over the products in your subscriptions and you can access most data.

When you add new users, if you don't assign them an admin role then they are in the user role and don't have admin privileges to any of the Microsoft admin centers. But if you need help getting things done, you can assign an admin role to a user. 

For example, if you need someone to help reset passwords, you shouldn't assign them the global admin role, you should assign them the password admin role. Having too many global admins, with unlimited access to your data and online business, is a security risk.

You can assign users to a role in 2 different ways:

• Go to the user's details and Manage roles to assign a role to the user. (Or)
• Go to Roles and select the role, and then add multiple users to it.

Assign admin roles to users using Roles :

• In the admin center, go to Roles. Choose the Azure AD or Intune tabs to view the admin roles available for your organization.
• Select the admin role that you want to assign the user to.
• Select Assigned admins > Add.
• Type the user's display name or username, and then select the user from the list of suggestions.
• Add multiple users until you're done.
• Select Save, and then the user will be added to the list of assigned admins.

Assign a user to an admin role from Active users :

• In the admin center, go to Users > Active users page.
• On the Active users page, select the user whose admin role you want to change. In the flyout pane, under Roles, select Manage roles.
• Select the admin role that you want to assign to the user. If you don't see the role you're looking for, select Show all at the bottom of the list.

Check admin roles in your organization :

You might not have the correct permissions to assign admin roles to other users. Check to make sure you have the correct permissions or ask another admin to assign roles for you.

You can check admin role permissions in 2 different ways:

• Go to the user's details and look under Roles on the Account page. (Or)
• Go to Roles and select the admin role, and select assigned admins to see which users are assigned.

Reference :

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-administering-power-bi-in-your-organization

https://docs.microsoft.com/en-us/microsoft-365/admin/add-users/assign-admin-roles?view=o365-worldwide

What are the key Features of Power BI Free, Pro and Premium

What are key differences between Power BI Free vs Pro vs Premium

Lets have a quick introduction about Power BI.
What is Power BI :
Power BI is a collection of software services, apps, and connectors that work together to turn your unrelated sources of data into coherent, visually immersive, and interactive insights. Your data source may be an Excel spreadsheet, or a collection of cloud-based and on-premises hybrid data warehouses. Power BI lets you easily connect to your data sources, visualize and discover what's important, and share that with anyone or everyone you want.
The key parts of Power BI :
Power BI consists of several elements that all work together, starting with these three basics:
Power BI Desktop : A Windows desktop application.
Power BI Service : An online SaaS (Software as a Service) service. 
Power BI Mobile :  An app version for Windows, iOS, and Android devices.

These three elements--Power BI Desktop, the service, and the mobile apps--are designed to let you create, share, and consume business insights in the way that serves you and your role most effectively.

Beyond those three, Power BI also features two other elements:
Power BI Report Builder : 

A tool for creating paginated reports to share in the Power BI service. 
Power BI Report Server : 

An on-premises report server where you can publish your Power BI reports, after creating them in Power BI Desktop.

Power BI Report Server is a solution that you deploy behind your firewall and then deliver your reports to the right users in different ways, whether that's viewing them in a web browser, on a mobile device, or as an email. And because Power BI Report Server is compatible with Power BI in the cloud, you can move to the cloud when you're ready.

The flow of work in Power BI :

One common workflow in Power BI begins by connecting to data sources in Power BI Desktop and building a report. You then publish that report from Power BI Desktop to the Power BI service, and share it so business users in the Power BI service and on mobile devices can view and interact with the report.

Another workflow involves paginated reports in the Power BI service. The Enterprise report creators design paginated reports to be printed or shared. They can also share these reports in the Power BI service. They're called paginated because they're formatted to fit well on a page. They're often used for operational reports, or for printing forms such as invoices or transcripts. They display all the data in a table, even if the table spans multiple pages. Power BI Report Builder is the standalone tool for authoring paginated reports.

Now will discuss about the key features and differences between the Power BI Free, Pro and Premium

1) Power BI Free :

Power BI Free enables you to connect to 70+ data sources, publish to the web, and export to excel. There are some limitations to the free version, for e.g. you can’t do peer-to-peer sharing and you can’t create App workspaces. However, the free version is great for doing your own analysis and don’t need to distribute the analysis to other end users. 

You also have the connectivity options like Direct Query, live connection, and the use of the gateway. The same visualizations that are available in Power BI Pro are also available in the Power BI Free.

Notes:

If an Organization has Power BI Premium capacity-based license, the it allows users with a free license to act on content in workspaces that are assigned to Premium capacity. 

Outside of Premium capacity, a user with a free license can only use the Power BI service to connect to data and create reports and dashboards in My Workspace. They can't share the content with others or publish content to other workspaces.

Power BI Free vs. Pro :

2) Power BI Pro:

Power BI Pro is an individual user license that lets users read and interact with reports and dashboards that others have published to the Power BI service. Users with this license type can share content and collaborate with other Power BI Pro users. Only Power BI Pro users can publish or share content with other users or consume content that's created by others, unless a Power BI Premium capacity hosts that content.

You can sign up for a free 60-day individual trial of Power BI Pro. Select the upgrade dialog that appears in the Power BI service whenever you try to use a Pro feature.

Key features of the Power BI Pro:

The Power BI Pro cost is around $9.99(USD)/user/month. It is also included in the Office365 Enterprise E5. It offers the following key features:

On-Premise Data Gateways:
If your data resides On-Premise (not somewhere in the cloud), you can now connect to this data and analyze it. A common example of this is a self-hosted SQL database.
More Data Storage :
Power BI Pro allows you up to 10 GB per Power BI Pro License. The free version caps you at 1GB per user.
Better Data Refreshes :
In Power BI Pro, you can better schedule(8 times per day) data refreshes so that your team always has the latest version of your data.
Sharing and Collaboration:
It allows you to share your data with individual coworkers or publish enterprise-wide “content packs” and “apps” with row-level data security. You can neither share with others nor consume shared content with Power BI Free. Everyone that you want to share content with must be assigned a Power BI Pro license, unless you decided to upgrade to Power BI Premium.

Notes :

A Power BI license with free and Pro per-user license only uses a shared and limited capacity to process content. If content is stored in that shared capacity, users who are assigned with a Power BI Pro license can collaborate only with other Power BI Pro users. 

They can consume content shared by other users, publish content to app workspaces, share dashboards, and subscribe to dashboards and reports. When workspaces are in Premium capacity, Pro users may distribute content to users who don't have a Power BI Pro license.

When using Premium Per User licenses, content created by a Premium Per User licensed user can only be shared with other users that have a Premium license, unless that content is specifically put on a workspace hosted on a Premium capacity.

How to Purchase Power BI Pro user licenses :

To purchase and assign licenses to members in the Microsoft 365 admin center, you must be a member of the global administrator or Billing administrator role in Microsoft 365.

After you buy licenses, you can assign them to users in either the Microsoft 365 admin center or the Azure portal.

You may follow these steps to purchase Power BI Pro licenses in the Microsoft 365 admin center:

• Sign in to the Microsoft 365 admin center.
• On the navigation menu, select Billing > Purchase services.
• Search or scroll to find the subscription you want to buy. You'll find Power BI under Other categories that might interest you near the bottom of the page. Select the link to view the Power BI subscriptions available to your organization.
• Select Power BI Pro.
• On the Purchase services page, select Buy.
• Choose Pay monthly or Pay for a full year, according to how you want to pay.
• Under How many users do you want? enter the number of licenses to buy, then select Check out now to complete the transaction.
• To verify your purchase, go to Billing > Products & services and look for Power BI Pro.
• To add more licenses later, locate Power BI Pro on the Products & services page, and then select Add/Remove licenses.

How to Assign licenses in the Azure portal

You may follow these steps to assign Power BI Pro licenses to individual user accounts:

• Sign in to the Azure portal.
• Search for and select Azure Active Directory.
• Under Manage on the Azure Active Directory resource menu, select Licenses.
• Select All products from the Licenses - Overview resource menu, then select Power BI Pro to display the list of licensed users.
• From the command bar, select + Assign. On the Assign license page, first choose a user, then select Assignment options to turn on a Power BI Pro license for the selected user account.

3) Power BI Premium :

Power BI Premium is an organizational subscription that provides a different way to store content in a virtual container called a capacity. With Premium capacity, anyone with permissions, whether they're inside or outside your organization, can view content stored in this Premium capacity, without purchasing individual Power BI Pro or Premium per-user licenses.

The Premium is designed from the ground up to address the challenges of large enterprise deployments and demanding workloads. A new service architecture was created to optimize for these enterprise scenarios, including the ability for organizations to serve a large number of “readers/viewers” who simply need to view and explore dashboards and reports in a cost-effective manner and without needing to license each user individually.

The Apps and App Workspaces with a diamond icon indicates that the content is stored in Premium capacity.

Premium capacity enables widespread distribution of content by Pro users without requiring Pro licenses for the recipients who view the content. 

The person who is creating content in the Premium capacity uses a Pro licenses to connect to data sources, model data, and create reports and dashboards that are saved to a workspace in Premium capacity. 

Users without a Pro license can still access a workspace that's in Power BI Premium capacity, as long as they're assigned a role in that workspace. If the workspace owner creates an app based on content in that workspace, users without a Pro license can still view that app in the Premium capacity, as long as they've been given permissions for that app.

Within those workspaces, developers assign roles, like Viewer, Contributor, Member, and the Administrator. These roles determine the extent to which the colleagues can interact with the content.

When a Developer creates and publishes an app, they grant access to entire organizations or individuals. The extent to which you can interact with the app's content depends on specific access permissions given to you. 

For example, you may be given access to view the app, connect to the underlying datasets, make copies of reports, or share the content.

Key features of the Power BI Premium:

Separate Resources:

No more “noisy neighbors”. Power BI Premium gives you your own processing environment, so your Power BI operations can’t be slowed down by other users that aren’t even within your company.

More Storage:

Your company gets up to 100 TB of data storage to share in Power BI Premium.

Larger Datasets:

Power BI Premium allows you to work with datasets up to 50 GB in size.

Free User Access to Shared Content:

If you use Power BI Premium, then free users are able to consume shared reports and dashboards.

Power BI Pro vs Premium: (Note: Subject to Change in Future)

The following are the key comparisons between Power BI Pro and Premium as of now.

Dedicated capacity with Power BI Premium :

The Power BI Premium offering introduces the concept of dedicated capacity, and it is the heart of the offering. Power BI Premium enables dedicated capacity, a set of the resources (memory, processors, hardware) reserved for the exclusive use by you, the customer.

Dedicated capacity nodes: the v-cores :

Of course, different BI workloads will require different compute power. Supporting hundreds of users of few reports and dashboards is very different than enabling 100,000 users to consume many BI applications.

When you decide to purchase Power BI Premium, you will need to provision enough capacity to support your workload. Capacity is provisioned through purchasing capacity nodes. 

The capacity nodes you purchase have a certain number of v-cores (“virtual cores”), memory, and bandwidth that will need to be sufficient to power your BI system. Each node is composed of a number of v-cores: frontend cores and backend cores.

The frontend cores are responsible for the web service, dashboard and report document management, access rights management, scheduling, APIs, uploads and downloads, and generally for everything that relates to the user experience.

The backend cores are responsible for heavy liftings: query processing, cache management , running R servers, data refresh, natural language processing, real-time feeds, and server-side rendering of reports and images. 

With the backend cores, a certain amount of memory is reserved as well. Having sufficient memory becomes especially important when dealing with large data models or with a large number of active datasets.

The backend cores that do the heavy lifting are fully dedicated to you, and they will not be shared by others. The frontend cores are shared with others, and they are computed as your portion in the pool of machines that handles the shared frontend services in Power BI.

At launch, Microsoft will offer three sizes for Premium capacity: P1, P2, and P3. Each comes with a different number of v-cores and memory size:

The Storage is set to 100 TB per capacity node.

The resources and limits of each Premium SKU (and equivalently sized A SKU) are described in the following table :

How much capacity needed?

You should plan on provisioning enough capacity to be able to comfortably handle your peak usage. Make sure to plan for some offline scheduled activities such as data refresh, smart alerting, or broad email distributions. If you have not reserved sufficient capacity, your cores could become overloaded and the responsiveness of the system will suffer.

Microsoft has provided a Capacity Calculator on its website to help you plan your Power BI Premium deployment. 

https://powerbi.microsoft.com/en-us/calculator/

The calculator uses a simple usage model based on Microsoft experience across many different organizations. However, the variability of the usage patterns is very significant and will depend on many factors including the specific data models used, the number of queries and their complexity, the hourly distribution of the usage of the service, the data refresh rates, the use of advanced features like Q&A, R and email distributions, and other usage patterns. As such you must use the calculator with caution and with tempered expectations, estimating capacity is not an exact science and performance cannot be guaranteed.

Sample Calculation:

Please Note:

Images/Content Source: docs.microsoft.com / powerbi.microsoft.com

Please note that, I have consolidated the multiple related topics in to one single article, only for the sake of user Knowledge purpose only, not for any Decision making. There could be manual/typo errors while preparing this article. Also note that, this information is subject to change in future.

--------------------------------------------------------------------------------------------------------

Thanks

--------------------------------------------------------------------------------------------------------

What are the various User Roles available in Power BI Workspaces

Roles in the Power BI Workspaces
The Roles let us manage who can do what in the new workspaces, so teams can collaborate. New workspaces allow you to assign roles to individuals, and to user groups: security groups, Microsoft 365 groups, and distribution lists.
To grant access to a new workspace, assign those user groups or individuals to one of the workspace roles: 

1. Admin
2. Member
3. Contributor
4. Viewer

Everyone in a user group gets the role you've assigned. If someone is in several user groups, they get the highest level of permission provided by the roles they're assigned. If you nest user groups, all the contained users have permission. All of these capabilities, except viewing and interacting, require a Power BI Pro license.

Now we will discuss in detail about each Role and its permissions :

Viewer :

This is a very basic, read-only Role that will be assigned to End users to allows them to view content of the workspace. It provides access to view every report, dashboard and workbook in that workspace. User with this role won’t be able to use Analyze in Excel option on reports, and won’t be able to access datasets or dataflows.

The Viewers are generally the App users who access/view the Reports from the App, instead of  going to the Workspace. 

The Power BI Apps, creates a good separation between the DEV and USER environment.

Contributor :

The Contributor role is generally assigned for the developers in the workspace. This role provides the access not only to reports, dashboards, but also to the datasets and dataflows. Users with this role can Edit the content as well as deleting it. They can publish a report into the workspace, or remove it but they cannot Publish / Un-Publish the App.

The contributor role gives them access to do all their development work in the workspace, with the following capabilities :

• Publish a report into the workspace
• Edit the content in the workspace
• Delete the content in the workspace
• Access to all workspace objects: reports, dashboard, workbook, dataset, and dataflow
• Copy content, use Analyze in Excel and etc.

Member :

The Member role provides the all Contributor role’s capabilities, additionally it grants the ability to Publish an App, or Unpublish it, or Update the App. 

We can treat this role as the Deployment Role. With this role, we can publish the content of a workspace as an App for the end-users. The Member role is having one of the most important actions in the workspace like migrating the content from DEV to USER environment.

The Member role also can set the access for Member-level roles or underneath (Contributor, or Viewer) for the users in the workspace.

Also the Member role allows us to do the individual sharing of reports and dashboards in the Workspace.

Admin :

The admin role provides the full access to the workspace. In addition to having the capabilities of all the Member’s role actions, the Admin can add or remove the Admins to the workspace, can update or delete the workspace.

-------------------------------------------------------------------------------------------------------- 

Thanks, TAMATAM ; Business Intelligence & Analytics Professional 

--------------------------------------------------------------------------------------------------------