How to refresh a gateway running on Azure VM

0 votes

Hi,

I am trying to refresh a data gateway to run on  a Windows server VM which is hosted on Azure

The challenge is whenever I am refreshing my dataset on Power BI service, an error message is displayed saying "The key didn't match any rows in the table

A sample of which is shown below:

Underlying error code:
-2147467259 Table: org_site.
Underlying error message:
The key didn't match any rows in the table.
DM_ErrorDetailNameCode_UnderlyingHResult:
-2147467259
Microsoft.Data.Mashup.ValueError.Key:
[Schema = "d1272", Item = "org_site"]
Microsoft.Data.Mashup.ValueError.Reason:
Expression.Error
Cluster URI:
WABI-WEST-EUROPE-B-PRIMARY-redirect.analysis.windows.net

I have installed the latest npgsql on the server(v4.0.7) .

Jun 10, 2019 in Power BI by Phalguni
• 1,020 points
502 views

1 answer to this question.

0 votes
You can easily resolve this error by changing the accounts.

If the user account used to connect the PG is set to "public" as default and the data for Power BI reports were all in another default schema

All you need to do is set up another db account whose default schema ("default search path") was "d1272"

Hope This Helps!!
answered Jun 10, 2019 by avantika
• 1,500 points

Related Questions In Power BI

0 votes
1 answer

How to troubleshoot a refresh on data set in power bi service

Hello, @vnk, You may see an error when ...READ MORE

answered Sep 14, 2020 in Power BI by Gitika
• 65,870 points
103 views
0 votes
1 answer

How to add multiple reference lines on a bar/ column graph?

Hi, Follow below steps: 1. Add a bar/ column ...READ MORE

answered Mar 26, 2019 in Power BI by Cherukuri
• 32,930 points
4,097 views
0 votes
1 answer

How to use a gateway in Power Bi?

Follow the below procedure - 1. Install ...READ MORE

answered Oct 29, 2019 in Power BI by rachael
188 views
0 votes
1 answer

How to ignore a slicer for one measure, but apply it on another?

In order to ignore Slicer you need ...READ MORE

answered Oct 1, 2020 in Power BI by Gitika
• 65,870 points
1,536 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,930 points
223 views
0 votes
1 answer

Stacked chart with dates on X-axis

Hi, @Hacke Regarding your query, you can follow ...READ MORE

answered Jun 30, 2020 in Power BI by Gitika
• 65,870 points
360 views
0 votes
1 answer

Install Power BI Desktop

It’s a pretty simple process. All you ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,310 points
222 views
0 votes
1 answer

Few tips before I start creating Power BI dashboard

It’s always advisable to begin with the data ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 52,310 points
182 views
0 votes
1 answer

How to sum a data table in Power BI?

It's a good practice if you avoid ...READ MORE

answered May 17, 2019 in Power BI by avantika
• 1,500 points

edited May 17, 2019 by Omkar 4,349 views
0 votes
1 answer

How to Filter a Query?

Hi, You can do the same in Power ...READ MORE

answered Jun 14, 2019 in Power BI by avantika
• 1,500 points
105 views