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,
I am trying to connect to SSAS tabular cube. Below are details
1) Mine is standlone system.
2) For login to system no Domain required.
3) Sql server is also installed on same machine. I am able to connect and browse the cube
4) I am able to connect to Sql server database using Enterprise gateway.
Issue:
a) I am not able to connect to SSAS cube using Analysis service Connector because of 'Effective User Name mismatch' error.
b) If I am trying to connect through Enterprise gateway, it is not connecting. Might be because no domain configured.
Anyone, please advice.
Thanks
Nitin
Your SSAS server has to be attached to a domain.
Hi,
Thanks for your reply.
Any way of doing it without domain.
Thanks
Nitin
@NitinSaluja the work around would be to http enable your ssas server via msmdpump.dll. This method is currently not support in Power BI But you can goto the following link to vote for the idea and maybe support will be added in the future.
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.