Can't connect live to SSAS in Power bi desktop March release

[ysapiyev]

Hi everyone,

I've got error while connecting live to SSAS in power bi. Error shows that my credentials are don't have permission to access them. However, when I use import instead of live connection, I see database and can import data. What is the issue for such behavior?

Regards,

Yerkhan

[v-yuezhe-msft]

@ysapiyev,

Do you connect to Multidimensional model or Tabular model? What version of SQL Server Analysis Service do you connect to?

Please note that servers must be running SQL Server 2012 SP1 CU4 or later versions of Analysis Services for the Power BI Desktop SSAS MD connector to work properly in live connection mode.

Regards,
Lydia

[ysapiyev]

@v-yuezhe-msft

I connect to multidimensional model. Version of Sql Analysis server is 14.0.1.

I found this issue when I installed 32 bit version of PBI desktop. Because 64 bit version gave me error clr20r3 while launch. As one of the suggestions I found is to change version.

Regards,

Yerkhan

[v-yuezhe-msft]

@ysapiyev,

Do you use 32 bit or 64 bit SQL Server? How about you use Power BI desktop May release to connect to the SSAS database?

Regards,
Lydia

[ysapiyev]

@v-yuezhe-msft

I have SQL Server 2017 64 bit. May version is not compatible with Report Server, therefore I can't use it.

[v-yuezhe-msft]

@ysapiyev,

What do you mean "May version is not compatible with Report Server"? Do you use Power BI Desktop report server or Power BI Desktop? What is the full error message when you use 64 bit Power BI Desktop?

Regards,
Lydia

[ysapiyev]

@v-yuezhe-msft,

I use marche release of Power BI desktop report server. 

Full error:

Problem signature:
  Problem Event Name:	CLR20r3
  Problem Signature 01:	PBIDesktop.exe
  Problem Signature 02:	2.56.5023.1043
  Problem Signature 03:	5aaae725
  Problem Signature 04:	System.Configuration
  Problem Signature 05:	4.7.2053.0
  Problem Signature 06:	58fa6ce4
  Problem Signature 07:	262
  Problem Signature 08:	9
  Problem Signature 09:	System.TypeInitialization
  OS Version:	6.3.9600.2.0.0.272.7
  Locale ID:	1033
  Additional Information 1:	13a5
  Additional Information 2:	13a5a7149e87cb7e60c3760e04f8bfd3
  Additional Information 3:	6c79
  Additional Information 4:	6c794f13606293cec8deabbb437d3be9

Regards,

Yerkhan

[v-yuezhe-msft]

@ysapiyev,

For report server issues, please post question in Power BI report server forum to get better support.

Regards,
Lydia