Forum Discussion

YingB's avatar
YingB
Frequent Visitor
2 years ago

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 respondin...
Need Help
TomMartens's avatar
TomMartens
Icon for Super User rankSuper User
2 years ago

Hey YingB ,

 

please check this article: https://learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-enterprise-manage-ssas?WT.mc_id=DP-MVP-5003068
Mapping of accounts is required. You authenticate to the Power BI Service with an account that looks like [email protected] 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

YingB's avatar
YingB
Frequent Visitor
2 years ago

Hej, TomMartens 

Yes, my Power BI Service with an account that looks like [email protected] and is matched  my domain domain\account.

 

 

  • TomMartens's avatar
    TomMartens
    Icon for Super User rankSuper User
    2 years ago

    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