Power BI Gateway-Data source configuration

[Anonymous]

Hi Guys.,

I am facing issue while mapping datasource in gateway connection.

Respective datasource has already been configured under gateway cluster but can not map that in report.

Any suggestion would be appreciated.

Thank you in advance.

[v-shex-msft]

HI @Anonymous,

As aj1973 said, you need to configure the similar data source as same as your report dataset used. Configure Datasource not means you can feel free to configure the same type Datasource.
For these not matched Datasource, obviously they not able to mapping with your report datasets.

If you want to change the datasource on power bi service, you can refer to the following blog to achieve them based on parametrized connection string:

Using the Power BI Service Parameters to change connection strings (To possibly change between Dev and test) 

Regards,

Xiaoxin Sheng

[Anonymous · Accepted solution]

Thank you @aj1973  and @v-shex-msft 

The issue was not with the  Data sources string,Being an administrator I thought I would be able to see all the datasources mapped to the Gateway .But it seems I was not added in "Data source" Users hence my login was unable to detect the configured connection.

[Greg_Deckler]

So Add to gateway does not work?

[Anonymous]

@Greg_Deckler :

Datasource has already been configured and add to gateway will create again new entry .

How to remove these crossed marks data sources from Gateway connection of a report.?

[aj1973]

You need to check the connection string of your report and see if it is the same as what it is in the Cluster. Otherewise the Gateway wouldn't detect the source.