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 in Power BI by Phalguni
• 1,010 points
51 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 by Avantika
• 1,500 points

Related Questions In Power BI

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 in Power BI by Cherukuri
• 21,430 points
77 views
0 votes
1 answer

How to assign Power BI license to a new user

The assign license method of MS Graph API might ...READ MORE

answered Sep 25, 2018 in Power BI by Kalgi
• 39,330 points
52 views
0 votes
1 answer

How to create final table based on Joins of two tables in power BI?

Hi Nithin, It is easy and simple. 1. Go ...READ MORE

answered Mar 1 in Power BI by Cherukuri
• 21,430 points
102 views
0 votes
1 answer

How to add slicer from a different tables?

Hi, Join is normally performed to get ...READ MORE

answered Mar 1 in Power BI by Cherukuri
• 21,430 points
236 views
0 votes
1 answer

display the count of rows matching some criteria

Do you want to show a table ...READ MORE

answered Aug 5 in Power BI by anonymous
• 21,430 points
28 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
• 39,330 points
37 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
• 39,330 points
75 views
0 votes
1 answer

How do I format the KPI in Power BI

format the KPI by selecting the paint ...READ MORE

answered Oct 9, 2018 in Power BI by Kalgi
• 39,330 points
51 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 in Power BI by Avantika
• 1,500 points

edited May 17 by Omkar 66 views
0 votes
1 answer

How to Filter a Query?

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

answered Jun 14 in Power BI by Avantika
• 1,500 points
18 views