Forum Discussion
Gateway - PBI Services Connection Issue
Hi saimnaveed,
Sorry to know it didn’t help. Please consider reaching out to Microsoft Support. You can provide them with all the troubleshooting steps you've already taken, which will help them understand the issue better and provide a resolution. They might be able to identify something specific about your admin account setup or provide a solution that isn't immediately obvious.
Below is the link to create Microsoft Support ticket:
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn
Thank you
dns settings of vpc are enabled, security group of ec2 has all relevant rules, redshift sg allow inbound traffic from vpc, tried using ping and nslookup on ec2 instance on which pbi gateway is installed and in both ways it was not able to resolve the redshift cluster endpoint.
Whats the reasons for this anamolous behavior and how it can be resolved effectively?
Hi saimnaveed,
A few different scenarios could be responsible for this error:
- The server and database name don't match what was entered in Power BI Desktop and the data source configured for the gateway. These names must be the same. They aren't case sensitive.
- Your account isn't listed in the Users tab of the data source within the gateway configuration. You need to be added to that list by the administrator of the gateway.
- Your Power BI Desktop file has multiple data sources within it, and not all of those data sources are configured with the gateway. You need to have each data source defined with the gateway for the gateway to show up within semantic model.
If you find this post helpful, please mark it as an "Accept as Solution" and consider giving a KUDOS.
Thanks and Regards