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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
YingB
Regular Visitor

Problem with on-premise data gateway connection via proxy to onpremise SSAS

We cant authenticate for Power BI service dataset with onprem SSAS using the Onprem Gateway

  • Connection status is OK, no errors
    dataset looks refreshed, but no data in report
  • The SSAS is responding
  • The same gateway and proxy works with the same server/user for SQL server connection
    we have tried  different users/account, all being SSAS Server admin/Admin for the Cube
  • If I use “wrong” user or pwd I get an error already in Local connection, but not it this case, so seems like authentication works.

In gateway logs we have this: “<ccon>The following system error occurred:  The user name or password is incorrect. </ccon>”
In SSMS ssasprofile tracing we have this: user is domain user (matching with email-adress login powerbi service) which has right to full acess to the tabular and also administrator for the ssas instance.

YingB_0-1696945662870.png

 


I will try with latest version of Gateway, currently its last months, and also check on Gateway server if I can connect with Power BI Desktop. Then I’m out of ideas.
It seems we have a connection/authentication but no authorization

Can someone help us walk out this problem. we appreciate IT.

 

7 REPLIES 7
TomMartens
Super User
Super User

Hey @YingB ,

 

please check this article: https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-ssas?WT.mc...
Mapping of accounts is required. You authenticate to the Power BI Service with an account that looks like someone@someplace.com but authorization to SSAS requires a domain acccount that looks like this: domain\account

I always recommend using the Active Directory Lookup Mapping method, even if it requires some "tweaking" of a configuratio file.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany

Hej, @TomMartens 

Yes, my Power BI Service with an account that looks like someone@someplace.com and is matched  my domain domain\account.

YingB_0-1697013540242.png

 

 

Hey @YingB ,

from your answer, I do not understand how you map the Power BI Service authentication account to the domain\account. This mapping must be configured per the article I posted above. The screenshots you provided does not show how you configured this mapping either inside the Power BI Service or by adapting one of the on-premises gateway configuration files.

 

Regards,

Tom



Did I answer your question? Mark my post as a solution, this will help others!

Proud to be a Super User!
I accept Kudos 😉
Hamburg, Germany
GilbertQ
Super User
Super User

Thanks, so does it work when you try and render a report?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Yes, it worked fine when I try to render my report. 

But when I tried open my report from powerbi service website. it showed error below:

YingB_0-1697004362653.png

At same time I opened tracing in sqlserver profile  for ssas, it showed error as below:

YingB_1-1697004564183.png

When I opened gateway errorlog file, it showed as below:

YingB_2-1697004786003.png

When I created a powerbi report which is connected to sqlserver database and render it, it works fine. and I can open the report in powerbi service and refresh data without any issue.  Same onpremise gateway and proxy, data in the same server as ssas. 

YingB
Regular Visitor

Hi, @GilbertQ 

 

Yes, I can confirm that the domain\useraccount I have configured in the gateway can successfully log into the SSAS Server and this account also has admin right on the ssas server

GilbertQ
Super User
Super User

Hi @YingB 

 

Can you confirm that the domain\useraccount you have configured in the gateway can successfully log into the SSAS Server? And that this account also has Admin rights on the SSAS Server?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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