Forum Discussion
Embedding with Multi-Tenant data warehouse security concerns
1. The Multi Factor Authentication may work for me. I was attempting to use the conditional access feature in the Azure Portal, but wan't having much luck getting it to work. This MFA feature seems to work ok. I can restrict portal log in to the service, but programmatic access via ADAL still works.
2. The data warehouse is an On Premise SQL database that we will access via the data gateway.
Hi trevorgermain,
1. Programmatic access restriction might influence the normal access. I think. Maybe this could help: powerbi-admin-auditing.
2. About Data Gateway security. Please reference:
powerbi-admin-power-bi-security (The link of the whitebook is in the first paragraph.)
powerbi-gateway-onprem-indepth
Best Regards!
Dale
The following links all show that using Resource Owner Password flow is a bad idea. In fact, the latest version of the ADAL library for .Net Core has removed the UsernamePasswordCredential entirely.
https://github.com/Microsoft/PowerBI-CSharp/issues/30
https://github.com/Microsoft/PowerBI-CSharp/issues/95
https://github.com/AzureAD/azure-activedirectory-library-for-dotnet/issues/482
http://stackoverflow.com/a/29110987
http://stackoverflow.com/a/28597758
http://stackoverflow.com/a/26795582
http://stackoverflow.com/a/39250380
I can only assume that the idea of application permissions will be coming to the Power BI service in the very near future, or the team has completely dropped the ball on the embedding security story.
When can developers expect a proper embedding authentication scenario?