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
951 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
763 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,733 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,457 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,151 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
873 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,363 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,388 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
541 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
949 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,144 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