Direct Query Report gateway connection error

0 votes

I was trying to setup an enterprise gateway connection for a direct query report however this is the error that was generated:

any clue why , this is very generic error

Nov 19, 2020 in Power BI by anonymous
• 8,910 points
969 views

1 answer to this question.

0 votes

There can be many reasons for this error. The 400 ERROR means a bad HTTP request. Please update the on-premise gateway to the latest version. If you already have updated the gateway to the latest version, then you can refer to the 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.

answered Nov 19, 2020 by Gitika
• 65,910 points

Related Questions In Power BI

+2 votes
2 answers

Power BI service throwing 403 error when using token to embed Power BI report

To add to @Kalgi's answer, Also make ...READ MORE

answered Oct 3, 2018 in Power BI by Nilesh
• 7,050 points
5,399 views
0 votes
1 answer

Power Query Web request results in “CR must be followed by LF” Error

What I think is, it might look ...READ MORE

answered Oct 29, 2018 in Power BI by Shubham
• 13,490 points
1,550 views
+1 vote
2 answers

403 error thrown by power bi report server when trying to get list of data sets

Hey @saranya, Try removing the header and ...READ MORE

answered Oct 29, 2018 in Power BI by Kalgi
• 52,360 points
4,070 views
0 votes
1 answer

How to change import mode to direct mode of connection in powerBI

Create a new file connect in import ...READ MORE

answered Oct 29, 2020 in Power BI by anonymous
• 65,910 points
777 views
+1 vote
1 answer

display the count of rows matching some criteria

Do you want to show a table ...READ MORE

answered Aug 5, 2019 in Power BI by anonymous
• 33,030 points
899 views
0 votes
3 answers

How to add an extra column to the existing table in power bi query editor?

Click on edit queries after loading source ...READ MORE

answered Dec 16, 2020 in Power BI by Roshni
• 10,520 points
76,638 views
0 votes
1 answer

How to demote Headers in Power BI query editor?

Hi, There are the steps which you can ...READ MORE

answered Feb 3, 2020 in Power BI by Jitesh
18,457 views
0 votes
1 answer

How to Split Columns in Power BI?

Splitting columns in Power BI using the ...READ MORE

answered Jan 6 in Power BI by anonymous
• 1,180 points
560 views
0 votes
1 answer

Error refreshing dataset with direct query using on-premise gateway connection

What is your data source type? Could ...READ MORE

answered Nov 19, 2020 in Power BI by anonymous
• 65,910 points
978 views
0 votes
1 answer

Solving an error in my report query.

This situation typically happens when you have ...READ MORE

answered Nov 20, 2020 in Power BI by Gitika
• 65,910 points
515 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP