Cannot Refresh Data On Gateway

[Anonymous]

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

[v-deddai1-msft]

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

[Anonymous]

Hi @v-deddai1-msft 

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 

[v-deddai1-msft]

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

[Anonymous]

@v-deddai1-msft 

Hi - i noticed in the logs  that the user provided is false. In my gateway that works it authenticates using ADAL and it's redirected to our SSO. Nothing like this appears in the new logs for hte enterprisegatewayconfigurator. 

EnterpriseGatewayConfigurator.exe Information: 0 : (False) MSAL 4.7.0.0 MSAL.Desktop Microsoft Windows NT 6.2.9200.0 [07/08/2020 14:04:58 - f9f2e9c5-1e9e-4b63-aec6-7e73977b42a8] (UnknownClient: 0.0.0.0) MSAL MSAL.Desktop with assembly version '4.7.0.0'. CorrelationId(I removed this)
EnterpriseGatewayConfigurator.exe Information: 0 : (False) MSAL 4.7.0.0 MSAL.Desktop Microsoft Windows NT 6.2.9200.0 [07/08/2020 14:04:58 - [I removed this] (UnknownClient: 0.0.0.0) === InteractiveParameters Data ===
LoginHint provided: False
User provided: False
UseEmbeddedWebView: NotSpecified
ExtraScopesToConsent:
Prompt: select_account
HasCustomWebUi: False

[GilbertQ]

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?

[Anonymous]

the gateway is installed on the same machine as the CSV file. The gateway can access all ports. 

Is there a way to verify which locations on the machine that the gateway has access to?

[GilbertQ]

Hi there

how are you creating the data source in the Gateway?

[Anonymous]

I publish the report from PBI desktop to service. Inside the service I select schedule refresh for the dataset. From there I attempt to add that dataset to the gateway (path to the CSV is already populated), but I get an error