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 All,
I am using Data Gateway (Personal Mode) in one of our On-Prem Windows Server runnning SQL SERVER 2014
The Data Gateway can be seen Up and Running in Power BI Service
Whenever I setup the credentials I get below error
When I pass the incorrect credentials it returns the same error, so actually error is returned even before authentication takes place
Solved! Go to Solution.
On a Windows Server you should set up the Enterprise/Standard gateway, not the Personal Gateway.
Check your Proxy settings and make sure the gateway can successfully communicate with the Azure backend.
This has been resolved - It was actually a Network Issue pertains to NAT Loopback.
The network I have been working on does not support NAT Loopback - Data Gateway and SQL Server was installed on same network servers and I have been trying to connect the Data Gateway with SQL Server using Public IP rather than local IP - As I mentioned NAT Loopback was not enabled therefore Data Gateway was not able to access the SQL Server with Public IP. When it was setup using Local IP, it worked
Moreover, It is working with Personal Gateway too
would you mind showing a sanitized version of your connection string? It needs to end with ,8004 not with :8004
Standard Data Gateway installed and is up and running on my Power BI Service
But still I am unable to update my database crendentials and getting below error
Please note that
Data Gateway is configured using official domain Id
what made you choose that? Using the default service login is the safest and most robust option.
I cant find any option to configure Standard Data Gateway other than email id
Ah, sorry - that is fine (and will work with MFA). This step is not actually required for the gateway to function.
I was thinking of the gateway service (which is crucial to be running) that usually should run under the default service login.
You are getting an error 400 which might be pointing to a resource mismatch on your data source. Can you create another connection against a different SQL data source and see if you can reproduce the issue?
I tried connecting the different data base creating an entirely different report then published it but all in vain then I tried publishing it on a different workspace it didn't work
I think the error I am recieving could be related to SQL Server Browser - Please see below that SQL Server Browser is running with "Local Service", is it the right configuration for Data Gateway Connection ?
Also, I noticed that on SQL Server Folder We don't have any permission for user "PgiEgwService" - Can this be an issue
These two settings should not have an impact.
Do you have the option of uninstalling and reinstalling the gateway software? You would choose the "Recover a gateway" option when you launch the admin tool. This is also a great opportunity to test your recovery key.
Tried uninstalling and installing the gateway several times - tried recovering the existing gateway and it was successful but still the same error occurs everytime on Power BI Service
In logs of data gateway there is a file FailedFileNames.txt
C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises data gateway\GatewayErrors20220916.000000000.log,
C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises data gateway\GatewayInfo20220916.000000000.log,
C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises data gateway\GatewayNetwork20220916.000000000.log,
C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises data gateway\SapAdapter20220916.000000000.log,
C:\Users\chms03\AppData\Local\Microsoft\On-premises data gateway\GatewayConfigurator20220916.000000000.log
Opening the first file GatewayErrors20220916.000000000.log
I can see this error
" A network-related or instance-specific error occurred.."
This has been resolved - It was actually a Network Issue pertains to NAT Loopback.
The network I have been working on does not support NAT Loopback - Data Gateway and SQL Server was installed on same network servers and I have been trying to connect the Data Gateway with SQL Server using Public IP rather than local IP - As I mentioned NAT Loopback was not enabled therefore Data Gateway was not able to access the SQL Server with Public IP. When it was setup using Local IP, it worked
Moreover, It is working with Personal Gateway too
On a Windows Server you should set up the Enterprise/Standard gateway, not the Personal Gateway.
Check your Proxy settings and make sure the gateway can successfully communicate with the Azure backend.
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.
User | Count |
---|---|
12 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
22 | |
3 | |
2 | |
2 | |
2 |