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,880 points
37 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,850 points

Related Questions In Power BI

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,200 points
1,763 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
1,193 views
+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,020 points
2,255 views
0 votes
1 answer

What options do I have for viewing and working with data on premises

There are three ways to achieve the ...READ MORE

answered Oct 15, 2018 in Power BI by Hannah
• 18,550 points
81 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
• 32,890 points
194 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,400 points
13,579 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
5,497 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,400 points
118 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,850 points
41 views
+3 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
• 32,890 points
44,757 views