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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
NitinSaluja
Regular Visitor

Having Issue: Connecting SSAS Tabular on standalone system without Domin

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

3 REPLIES 3
PowerBIGuy
Responsive Resident
Responsive Resident

Your SSAS server has to be attached to a domain. 

Business Intelligence Architect / Consultant

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. 

Business Intelligence Architect / Consultant

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors