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.
I am trying to use a Windows login with the Windows authentication method as the credentials for an enterprise gateway connection and keep getting the following error:
{"error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","pbi.error":{"code":"DM_GWPipeline_Gateway_InvalidConnectionCredentials","parameters":{},"details":[],"exceptionCulprit":1}}} Table: 1PD.
The Windows account can successfully query the database tables being used in the report so I am unsure of where to go from here.
Solved! Go to Solution.
The issue turned out to be the firewall. The gateway server and the database servers are on different subnets in our network schema and we needed to allow traffic on the following ports between the servers:
TCP 1521
TCP 443
TCP 5671-5672
TCP 9350-9354
The issue turned out to be the firewall. The gateway server and the database servers are on different subnets in our network schema and we needed to allow traffic on the following ports between the servers:
TCP 1521
TCP 443
TCP 5671-5672
TCP 9350-9354
I verified the user account can run the same query that the workbook is using in the database through SSMS. That's what is making it difficult to troubleshoot and confusing me about the error message, the database permissions are set up correctly. 1PD is the database name, the report is built off of a view in the 1PD database.
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.