I am considering a scenario where an organisation has the following:
- Organisational Entra Id tenant. This includes their own users and is associated with PowerBi/fabric licensing (Premium amd pro)
- External Entra Id which will use the 'local' directory of users.
There is RLS based on the username/role
There are two main requirements:
- share reports with the consumers - this can be achieved via service principal 'app owns the data'
- enable self-serve of users analytical needs. This can be achieved in various ways - e.g. using an async data request functionality (user will be given access to a flat file (e.g. a csv)). However, one thing I am considering is 'analyze in excel' which would enable access to the up to date data. As I understand it the user itself would need to be added to the workspace and given adequate permission to the semantic model. I was wondering if it is possible in my scenario if I would nit want them to be part of the organization entra id (the documentation suggests a 'no')
To summarize - my question is: Is it possible to enable 'analyze in excel' in powerbi reports for users homed in Entra external id tenant?
Some links
