Forum Discussion
SAP HANA LDAP Authentication Fails with Power BI
Wanted to provide an update/solution to this problem.
The problem is related to how you install PowerBI Desktop. If you install the application through the Microsoft Store, HANA ldap authentication does NOT work. If you install PowerBI Desktop through the standalone installer, provided at, https://www.microsoft.com/en-us/download/details.aspx?id=58494, then HANA ldap authentication works as expected. We have tested this on over a dozen machines with over a dozen user accounts, and all were fixed by uninstalling through the Microsoft Store, and installing the standalone package.
So, obviously something is broken with the app provided through the Microsoft Store. I hope this saves someone else weeks of troubleshooting....
-Brian
Community SupportHi gerretbp ,
This might be relatde to unsupported, I didn't see the official document about this. You could refer to this idea for details.
By the way, if you connect to it by ODBC to see whether it or not and please check whether the credential is correct or not. You could refer to LDAP User Authentication for details.
Best Regards,
Zoe Zhi
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Dax,
Thanks for the response.
HANA is properly configured, as we are able to connect with the same users, using LDAP, for other applications (Tableau, etc.). So it appears Power BI simply doesn't support LDAP to HANA. We'll see if we can submit a feature request somewhere for this functionality.
-Brian
Wanted to provide an update/solution to this problem.
The problem is related to how you install PowerBI Desktop. If you install the application through the Microsoft Store, HANA ldap authentication does NOT work. If you install PowerBI Desktop through the standalone installer, provided at, https://www.microsoft.com/en-us/download/details.aspx?id=58494, then HANA ldap authentication works as expected. We have tested this on over a dozen machines with over a dozen user accounts, and all were fixed by uninstalling through the Microsoft Store, and installing the standalone package.
So, obviously something is broken with the app provided through the Microsoft Store. I hope this saves someone else weeks of troubleshooting....
-Briani tried this way but it's not help me brother
