Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Calling all Data Engineers! Fabric Data Engineer (Exam DP-700) live sessions are back! Starting October 16th. Sign up.

Reply
saaccess
Frequent Visitor

Power BI with LDAP Authentication?

Hello Everyone,

 

I actually want to login PowerBI with local Active Directory Authentication. But PowerBI authenticates with Azure Active Directory.

 

My question is that, If I Sync my Local Active Directory with Azure Active Directory using Azure Active Directory Connect Tool, can PowerBI be authenticated locally using Windows Active Directory?  

 

Also, when I embed my powerbi Report into my Internal Web Portal, will the Embedded PowerBI report get Single-Singned-On?

 

Thanks in Advance!!!

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi @saaccess 

You can add local ad account to your group in azure portal. Then you can assign the account with power bi license(free, pro or other) in O365 admin portal, please refer to: https://docs.microsoft.com/en-us/power-bi/service-admin-purchasing-power-bi-pro#assign-licenses-in-o....

Synchronizing users’ identities between local and cloud directories is a great way to let users access different resources on both on-premises and cloud environments with just a single set of credentials. 

For reference: How to sync on-premises Active Directory to Azure Active Directory with Azure AD Connect?

Power BI Embed has two versions: user owns data / app owns data.

From your statement, I think you use user owns data. You need to sign in with accounts which has access to the report.

Here is a post with the similar problem: SSO with Graph API and Power BI Embed

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

 

 

 

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi @saaccess 

You can add local ad account to your group in azure portal. Then you can assign the account with power bi license(free, pro or other) in O365 admin portal, please refer to: https://docs.microsoft.com/en-us/power-bi/service-admin-purchasing-power-bi-pro#assign-licenses-in-o....

Synchronizing users’ identities between local and cloud directories is a great way to let users access different resources on both on-premises and cloud environments with just a single set of credentials. 

For reference: How to sync on-premises Active Directory to Azure Active Directory with Azure AD Connect?

Power BI Embed has two versions: user owns data / app owns data.

From your statement, I think you use user owns data. You need to sign in with accounts which has access to the report.

Here is a post with the similar problem: SSO with Graph API and Power BI Embed

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

 

 

 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.