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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
mcuros
New Member

Power Bi desktop : unable to connect to SSAS

I can't connect to SSAS from powerbi desktop. I get an error "The user was not authorized".

 

It works from excel on the same computer

11 REPLIES 11
fbrossard
Advocate V
Advocate V

How is configure your excel connection when it works (windows authent, or have you specified a user login+password)
Try to launch a sql sever profiler onto your ssas md instance in order to :
- control that the connection demand arrive to your instance
- view the returned error if the open session fails

I am getting the same error. "We could not connect to the Analysis Services server because the connection timed out or the server name is incorrect", although i can connect through Excel 2010. Please help.

wondering if you have this issue fixed. I am facing the same issue. Thank you

same issue here

Greg_Deckler
Super User
Super User

Can you turn on tracing and see what is up? File | Options | Options and settings | Diagnostics | Enable Tracing. Run the query, get the failure, check the trace folder.


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Thanks. 

 

The error is "Logon failure: unknown user name or password".  Maybe the problem is because the computer is not in the domain? 

 

If I select "Connect live" then the error is "We could not connect to the analysis services server because the connection timed out or the server name is incorrect."

 

If I select "Import data" and try to log in with Alternate credentials I get "The user was not authorized."  

 

Is there anything else I need to do ? And why is it working with the excel ? 

@mcuros - Are you using Power Query in Excel or no?


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

I tried PowerQuery and it does not work ..

 

 It only works in excel -> data

OK, wanted to verify since Excel Power Query and Desktop should essentially use the same technology. Next question, Multidimensional or Tabular? And, are you connectiving Live or Import?

 

If multidimensional, does the server meet these requirements:

  • 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
  • Only Enterprise and Business Intelligence editions of SQL Server are supported for MD connectivity
  • Display Folder, Cell level Formatting, KPI Trends, and translation features are not supported in this release of SSAS MD. These features will be enabled in upcoming releases of Power BI Desktop.

If Tabular, are you running an Enterprise Gateway or the old Analysis Services Gateway?

https://powerbi.microsoft.com/en-us/documentation/powerbi-desktop-analysis-services-tabular-data/

 

 


@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

I'm using tabular model with the old Analysis Services Gateway.    I tried to install an Enterprise Gateway but I can't because AD is on the same server. So im  stucked with the old one for now.

 

I have no problem connecting to the service from the online powerBi

The Enterprise Gateway can be on any machine that can see your SSAS server.  It doesn't have to be the SSAS server.  It will help if it is but not essential.


To learn more about DAX visit : aka.ms/practicalDAX

Proud to be a Datanaut!

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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