Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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.
Solved! Go to 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.
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:
Regards,
Xiaoxin Sheng
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.
So Add to gateway does not work?
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.?
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.
Regards
Amine Jerbi
If I answered your question, please mark this thread as accepted
and you can follow me on
My Website, LinkedIn and Facebook
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.