powerbi gateway service

Select:

Click Apply, then Data source credentials - > Provide same credentials as in Power BI Desktop when you pulled the source.

Hi ak77,
 Have you created the Gateway connection for the prod DB "vaim....windoes.net" which you have in the parameters? If not you need to create the cloud gateway connection as below.

After that you are able to see that connection in the gateway section and you can map to it and it will work.
Note: If you want to connect any other server you need to create the gateway connection for that with the mentioned steps above.

Hope this helps please consider as an accepted solution if works or give some kudos.

Hi ak77 

The parameters are disabled in your settings because your current account doesn't have the required administrative permissions on that gateway, or the parameter settings are locked by a previous owner of the dataset. To fix this and enable the data source mapping, you need to first make sure your gateway admin grants your account "Users" or "Connection Creator" permissions on that specific gateway (AZ-Gateway-01) within the Power BI Admin Portal. Once you have proper gateway permissions, go to the Data source credentials section just above your parameters, expand it, click Edit credentials to log into the database with your production service account, and then hit Apply at the bottom to unlock the gateway selection dropdown and bind your production database.

Hi ak77  ,

Thank you for posting your query in the Microsoft Fabric Community Forum.

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

Thank you.

Hi ak77,

Just checking in to see if your issue has been resolved. If you’re still facing any problems, please feel free to reach out and we’ll be happy to assist further.

Thank you.