| XLCubed is now FluenceXL. The new wiki can be found here: https://help.fluencexl.com/ |
Difference between revisions of "Excel Admin approval for Azure services"
| Line 9: | Line 9: | ||
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. | ||
| − | ;Azure Active Directory | + | ;Azure Active Directory Graph |
:Used to obtain user identity information. Required | :Used to obtain user identity information. Required | ||
;Azure Analysis Services | ;Azure Analysis Services | ||
Latest revision as of 09:38, 16 March 2023
When connecting to an Azure resource, for example Azure Analysis Services, XLCubed makes use of the XLCubed app registration (1b6a17fb-c1a3-4e56-9043-1d405c875bc7). The first time the XLCubed Excel client accesses an Azure resource in an organisation, an administrator will need to grant approval.
The XLCubed 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
