cancel
Showing results for 
Search instead for 
Did you mean: 

Error updating the report on the gateway

Hi colleagues, I have such a problem, when updating the report closes an error, can anyone have ideas ??

 

Underlying error code:-2147467259
Underlying error message:Unable to convert the value "[Table]" in type Table.
DM_ErrorDetailNameCode_UnderlyingHResult:-2147467259
Microsoft.Data.Mashup.ValueError.Reason:Expression.Error
Microsoft.Data.Mashup.ValueError.Value:[Table]
Cluster URI:WABI-WEST-EUROPE-D-PRIMARY-redirect.analysis.windows.net
Activity ID:e2f5c1b6-84e1-4ff8-90c4-998e95158e62
Request ID:82a1d02b-769a-4230-a443-38ea3276e6b2
Time:

2021-04-13 14:52:04Z

Status: New
Comments
v-lili6-msft
Community Support

hi

Try to download pbix file and refresh it power bi desktop to see if it has error in power query.

 

and also please make sure your gateway is latest version.

 

Regards,

Lin

taraskapral
Regular Visitor

I have exactly the same issue since Analysis Services (TFS) server has been updated to newest version. 

- Refresh in Power BI Desktop works and gets no error

- Gateway is online and updated to latest version
- Gateway connection is online

I tried to add new connection and same connection on different GW, but it did not help. It seems it's related to that TFS server upgrade, but we have no clue what we can do ti find the error. Any ideas?

{"error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","pbi.error":{"code":"DM_GWPipeline_Gateway_MashupDataAccessError","parameters":{},"details":[{"code":"DM_ErrorDetailNameCode_UnderlyingErrorCode","detail":{"type":1,"value":"-2147467259"}},{"code":"DM_ErrorDetailNameCode_UnderlyingErrorMessage","detail":{"type":1,"value":"The key didn't match any rows in the table."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Key","detail":{"type":1,"value":"[Id = \"Team System\"]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Table","detail":{"type":1,"value":"#table({\"Id\", \"Name\", \"Description\", \"Kind\", \"Data\"}, {})"}}],"exceptionCulprit":1}}} Table: tablename.