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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
Anonymous
Not applicable

Trouble adding Analysis Services credentials to On-Premises Data Gateway for Service Account

I'm trying to connect to an Analysis Services database in Power BI Service. When trying to connect live directly in the service, it says the connection method is being deprecated. Trying to publish the desktop file instead, it won't let me add credentials to the gateway. I'm trying to use a service account, which can access the Analysis Services database in SSMS successfully. This is the error message that I am getting when trying to add the data source in the gateway:

bobbyrauch11_0-1646844224085.png

 

8 REPLIES 8
nitishsh91
Solution Supplier
Solution Supplier

Hi @Anonymous 

 

Please check if you are able to connect to this SSAS server from the gateway server, try doing telnet(connectivity test) first to ensure the connectivity is there.

Anonymous
Not applicable

If the gateway is installed on a physical desktop, and that desktop is able to connect to the SSAS database in SSMS, does that mean the connection is open?

Yes, does your desktop id by which you are logged in has got access on SSAS server?

Anonymous
Not applicable

Yes, it has access to view the database data and its components, sources, etc.

Please can you confirm your datasource, is it Azure Analysis Services?

 

nitishsh91_0-1646854729673.png

 

Anonymous
Not applicable

It is a SQL Server Analysis Services connection

Please can you shar eyour data source settings?

 

nitishsh91_0-1646913291223.png

 

Also which gateway are you using and its version?

What level of access the account has on SSAS?

Is it hosted on default port 2383 or any other port?

Anonymous
Not applicable

bobbyrauch11_0-1646923476271.png

It is on the default port 2383, the access level for the AD group is Read on the cube (Kerberos authentication), gateway version 3000.110.5 Dec 2021 release 2

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

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

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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

Top Solution Authors
Top Kudoed Authors