Forum Discussion

troyhimes's avatar
troyhimes
Icon for Resolver I rankResolver I
2 years ago

Analysis Services as Data Connection in Gateway FAIL

I am an On-premises gateway novice.  I've successfully created data source gateway connections to databases and network based files.  I now have a semantic model with a connection to a separate service hosted semantic model.  I'm now trying to create a connection to that data source for the gateway.  In setup, only 'Authentication method' option is Windows and I use my Username and network Password (same username/password successfully used for other gateway data connections), but it fails returning error "Sibanye-PowerBI: Authentication failed: User ID and Password are required when user interface is not available".

 

Seems like I'm missing something basic, any ideas?

 

Thanks

Need Help

6 Replies

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

    Can you please provide a screenshot of the gateway configs (masking sensitive data)
    and also can you confirm whether it is Azure analysis service or On Prem/IaaS SSAS?

     

    That would help us help you better

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

        Can you also confirm whether it is an SSAS (analysis service in On Prem or IaaS) or Azure analysis service/Powerbi Premium equivalent of AAS?

         

        Based on your server name, it feels more of Powerbi premium equivalent; and in that case Azure analysis services and PowerBI Premium equivalent doesnt suppor windows authentication.

        It supports AD authentication /MFA based authentication; so ideally one cannot use a gateway for Azure Analysis service .

        The Gateway for analysis service is only for SSAS (On Prem/IaaS)

  • Kaarthi's avatar
    Kaarthi
    New Member
    1 year ago

    I have the same problem, I'm using powerbi ( premium P1) semantic model 

     

    Error: 

    Unable to create connection for the following reason: An invalid connection string has at least one of the passed arguments which does not meet the parameter specification. Please check the data source connection string.
    Details: DataGateway01: Authentication failed: User ID and Password are required when user interface is not available.

    datasource: powerbi://api.powerbi.com/v1.0/myorg/Global%20Commercial

    Data base : CRM Views - Update Direct

     

    Appreciate any help !!