cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
vatten
Frequent Visitor

live connection to ssas not possible

Evertytime I want to create a live conneciton to the SSAS, I´m forced to use the data import instead because the selection is switching from live connection to data import. I tried it with both SSAS 2012 & 2014 and also installed the latest version of the on-promise data gateway. All the SSAS connection are running but I can´t access them with PowerBI desktop. Does anybody had the same problem before?

15 REPLIES 15
vickyprudhvi Helper IV
Helper IV

Re: live connection to ssas not possible

Are you trying to conenct SSAS Tabular mor Multi dimensional model?

Super User III
Super User III

Re: live connection to ssas not possible

@vatten What version are you on, and have you already connected to a different data source where you imported the data?


Looking for more Power BI tips, tricks & tools? Check out PowerBI.tips the site I co-own with Mike Carlo. Also, if you are near SE WI? Join our PUG Milwaukee Brew City PUG
vatten
Frequent Visitor

Re: live connection to ssas not possible

I´m struggeling with the live connection to the multi dimensional model. I also established a live connection to SQL tables. That´s working fine...

vatten
Frequent Visitor

Re: live connection to ssas not possible

@Seth_C_Bauer I´m using PowerBI desktop version 2.37.4464.602 64bit and want to work against SSAS version 12.0.4100.1.

And yes, I´m using a live connection to SQL tables and my first report is based on an excel file. That´s also working fine. I can also import the data from the SSAS cube but I can´t establish the live connection.

 

Microsoft
Microsoft

Re: live connection to ssas not possible

Hi @vatten,

 

I have tested it on my local environment, I have the same issue if I donot enter a database name on the Database textbox. However, if i specify a specific database name, then everything works fine.

Capture.PNG

 

So in your scenario, please type a database name, and check if you can connect to your SSAS DB with live connection.

 

Regards,

Charlie Liao

vatten
Frequent Visitor

Re: live connection to ssas not possible

Hi @v-caliao-msft,

 

I tried both, with and without the datase name. In both times the selection is switching from live to data import

ssas.JPG

 

I even checked if my database user is not cerrect transferred to the SQL server, but if I enter a wrong datase name, my user is identified correctly.

ssas2.JPG

 

But thank you for testing

LuisQuedas Advocate I
Advocate I

Re: live connection to ssas not possible

Hi Vatten.

 

Did you try to fill in only the server name and leave Database blank, (once is optional)?

Are you sure the account you are using can access the OLAP Databases? You can try to set your account as SSAS Administrator.

If the account you are using is a SSAS Admin you will see all the OLAP databases avaliable on the Server.

 

Cheers, Luis

vickyprudhvi Helper IV
Helper IV

Re: live connection to ssas not possible

I am able to connect live to ssas Multi dimensional Model

Can u show us what error you are getting. a screen shot pls

vatten
Frequent Visitor

Re: live connection to ssas not possible

Hi Luis,

 

Yes, I tried both ways and yes, my user is a Admin user on the SQL server. Maybe the problem is somewhere in the Data Gateway. I also tested the connection with the office365 app and wanted to connect to the SSAS. That´s working so far and I can choose the different databases but no cubes.

ssas3.JPG

 

But when I open the dataset, an error messages tells me to contact the gateway administrator due to connection problems...

Helpful resources

Announcements
Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

‘Better Together’ Integration Forum Launch

‘Better Together’ Integration Forum Launch

We've launched a how-to forum where you can learn about how Power BI integrates with other Power Platform products.

Top Solution Authors
Top Kudoed Authors