Difference between revisions of "Excel Admin approval for Azure services"
m (Text replacement - "XLCubed" to "FluenceXL") |
|||
| Line 1: | Line 1: | ||
| − | When connecting to an Azure resource, for example Azure Analysis Services, | + | When connecting to an Azure resource, for example Azure Analysis Services, FluenceXL makes use of the FluenceXL app registration ({{Code|1b6a17fb-c1a3-4e56-9043-1d405c875bc7}}). The first time the FluenceXL Excel client accesses an Azure resource in an organisation, an administrator will need to grant approval. |
| − | The | + | The FluenceXL application uses these permissions to access the Azure data source in a managed way, allowing the administrator to have control over which permissions they grant, as described in this series of Microsoft articles about App registrations and Enterprise applications: [https://learn.microsoft.com/en-us/azure/active-directory/develop/app-objects-and-service-principals Microsoft article on Azure applications]. |
These are the API permissions it can use: | These are the API permissions it can use: | ||
| − | [[File: | + | [[File:FluenceXL app permissions.png|A screenshot showing the FluenceXL app registration API permissions]] |
Some of the permissions can be granted when required. For example, if access to PowerBI isn't needed, then the Power BI Service APIs can be omitted. | Some of the permissions can be granted when required. For example, if access to PowerBI isn't needed, then the Power BI Service APIs can be omitted. | ||
Latest revision as of 16:54, 3 July 2023
When connecting to an Azure resource, for example Azure Analysis Services, FluenceXL makes use of the FluenceXL app registration (1b6a17fb-c1a3-4e56-9043-1d405c875bc7). The first time the FluenceXL Excel client accesses an Azure resource in an organisation, an administrator will need to grant approval.
The FluenceXL application uses these permissions to access the Azure data source in a managed way, allowing the administrator to have control over which permissions they grant, as described in this series of Microsoft articles about App registrations and Enterprise applications: Microsoft article on Azure applications.
These are the API permissions it can use:
Some of the permissions can be granted when required. For example, if access to PowerBI isn't needed, then the Power BI Service APIs can be omitted.
- Azure Active Directory Graph
- Used to obtain user identity information. Required
- Azure Analysis Services
- Allows access to Azure Analysis Services data models
- Azure SQL Database
- Allows access to Azure SQL databases
- Power BI Service
- Allows access to Power BI models
