The mission is to give access to external organizations to our sql dbs, power bi and storage accounts (through AAD?), basically to consume our data. Here is a link to the external user access to AAD, have a look at the features available and let me what you think would be a good approach:
https://learn.microsoft.com/en-us/azure/active-directory/external-identities/compare-with-b2c