How to refresh a gateway running on Azure VM

Question

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) .

Answer 1

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!