Forum Discussion
Cannot Refresh Data On Gateway
I can insert completly invalid credentails and i still get the below error. Anyone know how to fix this?
this is just trying to read a CSV file on my desktop
8 Replies
- The error is saying that it cannot connect to the underlying CSV file
make sure that the Gateway server can access the location of the CSV file?- Hi there
how are you creating the data source in the Gateway?
Hi Anonymous ,
The 400 ERROR means a bad http request. Please updata on-premise gateway to the lastest version. If you already have updated the gateway to the latest version, then you can refer to steps below for troubleshooting.
1. Check if the server is using a proxy and the proxy. Some proxies restrict traffic to only ports 80 and 443. By default, communication to Azure Service Bus will occur on ports other than 443.
2. You can force the gateway to communicate with Azure Service Bus using HTTPS instead of direct TCP. You will need to modify the Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config file. Change the value from AutoDetect to Https. This file is located, by default, at C:\Program Files\On-premises data gateway.
3. Restart the gateway and check if the issue persists.
To stop the service, run this command:
''' net stop PBIEgwService '''
To start the service, run this command:
''' net start PBIEgwService '''
4. You may export the data gateway log by selecting Diagnostics and then selecting the Export logs link near the bottom of the page. Reference: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-tshoot#tools-for-troubleshooting.
Best Regards,
Dedmon Dai
I ran a diagnostic and the gateway was able to access all ports.
. I redownloaded the gateway a few hours ago and https was the default.
I had restarted the gateway as well.
ive been trying to troubleshoot this for a few weeks now
Hi Anonymous ,
If you have Pro account I suggest you try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".
Best Regards,
Dedmon Dai
