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, get a free DP-600 exam voucher to use by the end of 2024. Register 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
November Carousel

Fabric Community Update - November 2024

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

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

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