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
LeonardoVega
Frequent Visitor

Problems with SSAS Live Connection

Good Morning.
I have several problems with power bi desktop.
1.- I can't connect to a server using a vpn. The customer gave me a vpn to connect to your database. The problem is that I can't connect to the SQL Server Analysis Services database.
It says the server name is incorrect. The only way I can connect to SSAS is by using the runas command in cmd to run the program with the domain and the server administrator.

manchester runas.png

I need to find a way to connect to the VPN without the need to use cmd commands.

 

2.- Once connected to SSAS in live connection mode, I cannot customize the reports.

MANCHESTER ERRORES.png

I need create a measure and column in the report but most of the features of power bi are not enabled.
I have the need to specify roles in the roles manage to end users.
I need help solving these problems.

These two problems are from the same report.
Do you have any ideas?
Thank you so much.

2 REPLIES 2
vanessafvg
Super User
Super User

@LeonardoVega

 

I am not sure about the VPN bit, but if you are using an SSAS database in live connetion mode in power bi you will not be able to create measures, etc.  When you use SSAS all you can really do is create visuals because its expected that the data is fully modelling the way you want it.  If you need to enhance the model use Import mode.

 

If have flexibilty you can set up the roles in SSAS in live mode, if you import though you can use Row Level Security to manage roles.





If I took the time to answer your question and I came up with a solution, please mark my post as a solution and /or give kudos freely for the effort 🙂 Thank you!

Proud to be a Super User!




Thank you for sharing your valuable feedback. I have a question based on your revert. Without any measure group, how can we process the cube first? I had a word with Microsoft team, they informed us after 2 days validation, the problem arises from SSAS server, not BI. You need to contact ssas team.

 

If the same cube process using import mode then its publish and visible in the live BI server without any disturbance. Can anyone there to give us the proper way to publish the online cube.

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.