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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. 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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors