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
1,187 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!!

Ready to stand out in the world of data visualization? Explore our Tableau Certification Program and unlock a new realm of opportunities by validating your expertise in the industry's leading data visualization tool!

answered Jun 10, 2019 by Avantika
• 1,520 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,910 points
865 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
• 33,030 points
8,377 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
822 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,910 points
6,564 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
1,099 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,910 points
1,859 views
0 votes
1 answer

PowerBI - Actual & Planned Dates on Same X Axis

Yes, you may add two date columns ...READ MORE

answered Feb 15, 2022 in Power BI by CoolCoder
• 4,400 points
1,277 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,360 points
873 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,520 points

edited May 17, 2019 by Omkar 7,261 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,520 points
503 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