Analysis Services as Data Connection in Gateway FAIL

[troyhimes]

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

[Kaarthi]

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 !!

[NandanHegde]

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

[troyhimes]

[NandanHegde]

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]

In this case , how do we set the gateway for refresh

[lgaust]

Hey Kaarthi, 

Any chance you resolved this?
I'm getting the exact same issue.

@NandanHegde - it's all PowerBI/Saas; ie; we create a powerbi report and upload it to the service which creates a semantic model.

You share the semantic model with the appropriate security groups.

Create report #2; Get Data > PowerBI Semantic Model; select the model you want. Do whatever you want in the Report.

Publish Report #2 to PowerBI Service.

Here's where it gets funky;

* If you only have the linked Semantic model in Report #2, the report will work fine in PBI service and you do not need to do anything in the gateway; no connection is required

* If you added any other data source from your PBI Gateway to Report #2, the report will work fine in PBI Desktop, but when you upload it to PBI service, it will complain there is no Connection in PBI gateway.

So you click 'Create new' in the On Prem gateway area and you get the screen Kaarthi linked to above.

You enter valid network credentials and it doesn't work.

Alternatively if you create a new connection in PowerBI gateway for PowerBI Semantic Model; this will take the authentication and finish being able to be set up; however it doesn't exist in the drop down to attach the data source to for Report #2.

Any clarity on what the correct path is for using 2 data sources when using a gateway would be great as I'm tearing my hair out on this; I really don't want to have to recreate the logic of the initial semantic model again.