Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi everyone,
I try to make a connection to my SSAS cube via Standard on-premise data gateway and I always get an invalid username or password error!
Here are the configuration that I did after reading troubleshooting doc:
What am i missing? It's been quite a while that I am trying to figure out what I do not do correctly.
Thank you for your help,
Gervais.
@Anonymous
You need map the power bi email account to an account that has permission to access the as server. We normally use Domain/Username format instead of Email format to connect AS.
Manage your data source - Analysis Services - Power BI | Microsoft Docs
Paul Zheng _ Community Support Team
Best Regards
Hi Paul,
I did the mapping has you explain in your post.
I am able to connect to my SSAS server with my account Domain\Username when using SSMS.
When I verify the log of the on-premise data gateway, my doman\username is passed correctly in the connection string.
Still having the problem!
Thanks for your post.
G.
Did you check the below document?
Manage your data source - Analysis Services - Power BI | Microsoft Docs
Proud to be a Super User!
Hi FarhamAhmed,
Thanks for your response. I appreciate.
Yes I did. I verified every aspect included in this article, listen to both video.
I also change the Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config file
to set the ADUserNameLookupProperty and the ADUserNameReplacementProperty with my email-UPN has describe in the document without any success. The only thing I did not do is to set a value for the ADServerPath. Since the AD name resolution is running, I do not think it has any effect with my problem.
Any help will be welcome.
Have a good day.
Gervais.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
12 | |
7 | |
3 | |
3 | |
2 |
User | Count |
---|---|
15 | |
11 | |
5 | |
5 | |
2 |