User Profile
saimnaveed
New Member
Joined 1 year ago
User Widgets
Contributions
Re: Gateway - PBI Services Connection Issue
I have configured pbi gatewayso i am its administrator and i have created the data source connection so i am inlist of ldata source users. Problem is that I am able to create data source connection(using prinvate redshift cluster endpoint) but that connection never appears in the list of connections available to select in the settings of any semantic model so i am unable to use it. I have also tried configuring odbc based data source connection but it has the similar problem. Can somebody from pbi support or development team respond on this query?904Views0likes1CommentRe: Gateway - PBI Services Connection Issue
I am able to add data source connection under the configured gateway and its added after doing a connection test but any of that connection using redshift cluster endpoint is not available in the list of available data source connections in the settings of semantic model. Secondly I can query redshift db from ec2 isntance. So uptill now problem is not resolved922Views0likes3CommentsRe: Gateway - PBI Services Connection Issue
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?1KViews0likes1CommentGateway - PBI Services Connection Issue
Hi, I have a private redshift cluster and I want to connect it with semantic models on pbi services. For the connecting semantic model on pbi services to redshift cluster I have configured an aws ec2 instance in the same vpc in which redshift cluister resides and I have configured pbi data gateway on it. I am able to query redshift db table using commands in cmd of that ec2 instance. pbi gateway is visible in pbi services and its status is online Problem which I am facing is that when i create a new connection under that gateway using endpoint of redshift cluster, connection becomes visible in list of connections and shows status of online but it doesnot become available to choose in the list of connections to map uder gateway connections setting of any semantic model even after waiting for more than 1-2 days so i am unable to connect to redshift cluster using gateway and enpoint of redshift cluster but when i create a connection under that same gateway using enpoint of network load balancer, it gets created and becomes available to choose in the gateway connection settings. I have checked all settings of ec2 instance esp security group and others and they all seem fine. Please let me know how to solve this issue so that i can connect to redshift cluster through pbi gateway in pbi services using redshift endpoint otherwise configuring gateway in the vpc of redshift cluster seems useless exercise. Let me know you need some other infoSolved1.1KViews0likes9Comments
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.