live connection to ssas not possible

[vatten]

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?

[mibber]

I had the same issue.

First of all you have to have a SQL Server 2012 SP1 CU4 or newer.

Second it does not support SQL server standard edition on SQL2012 and SQL2014. In this case you need to have a Enterprise or a Business Intelligence Edtition of the SQL server. Live connection is supported for standard edition of the SQL2016.  

[danikayst]

I also have the same issue! Are there any solutions yet?

[MateuszBI]

I have exact same issue. When I try to connect live to SSAS MD the option from Connect Live switches to Import Data when I click "OK" button. Is there solution for that. I have SQL Server Standard 2014.

[MateuszBI]

I have exactly same issue. Is there resolution for that. When I do click Connect Live to SSAS MD optoin switches to Import Data.

[Seth_C_Bauer]

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

[vatten]

@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.

[v-caliao-msft]

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.

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]

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

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.

But thank you for testing

[LuisQuedas]

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

[vatten]

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.

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

[vickyprudhvi]

does importing data from SSAS Multidimenional is working ?

and what is the error u are getting next to the server name.

[vickyprudhvi]

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]

There is no error message shown in the powerbi desktop. The selection only switch from live to import. When I try the connection with the online version of powerbi I can list all the databases and select one (wondering why there are no cubes visable) but when I go into the dataset I can see the following error messages:

[vickyprudhvi]

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

[vatten]

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...