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

0 votes
Hi,

I get the following error message when trying to refresh my dataset.

The dataset is direct query using an on-premise data gateway (organization) and the server name in the gateway exactly matches that in my report data source.

I have other datasets using import method that work perfectly fine. Please could someone help advise?
Nov 19, 2020 in Power BI by anonymous
• 8,910 points
532 views

1 answer to this question.

0 votes

What is your data source type? Could you refresh the dataset successfully in desktop? Also, please check the status of connection string under gateway settings.

1.PNG

answered Nov 19, 2020 by anonymous
• 65,890 points

Related Questions In Power BI

0 votes
1 answer

Embeded Power BI report with service principal using on premise SSAS as dataset

On the data gateway that is being ...READ MORE

answered Feb 23 in Power BI by CoolCoder
• 4,360 points
136 views
0 votes
1 answer

Excel Power Query: Using List.MatchAny on a column value

try this. let TableA = ...READ MORE

answered Oct 22, 2018 in Power BI by Annie97
• 2,160 points
2,852 views
0 votes
0 answers

How to work on existing power query using python

Hi I have an existing power query created ...READ MORE

Feb 7, 2020 in Power BI by Biswajith
• 120 points
2,024 views
0 votes
1 answer

Query from Power BI to AI suddenly fails with (502): Bad Gateway

The AA Query frequently returns too much ...READ MORE

answered Feb 10 in Power BI by CoolCoder
• 4,360 points
420 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,050 points
441 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
58,280 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
15,397 views
0 votes
0 answers

How to Split Columns in Power BI?

Can anyone demonstrate how to split columns ...READ MORE

Feb 4, 2020 in Power BI by Roshni
• 10,520 points
274 views
0 votes
1 answer

Direct Query Report gateway connection error

There can be many reasons for this ...READ MORE

answered Nov 19, 2020 in Power BI by Gitika
• 65,890 points
461 views
+2 votes
3 answers

How to replace null values with custom values in Power BI(power query editor)?

Hi Nithin, To fill or replace the null or ...READ MORE

answered Mar 8, 2019 in Power BI by Cherukuri
• 33,050 points
112,879 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