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
978 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,910 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, 2022 in Power BI by CoolCoder
• 4,400 points
784 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
3,768 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,473 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, 2022 in Power BI by CoolCoder
• 4,400 points
1,176 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
898 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

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,910 points
969 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,030 points
151,958 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