Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

sgorin

Error updating the report on the gateway

Submitted by on ‎04-13-2021 09:39 AM

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
See more ideas labeled with:
2 Comments (2 New)
Comments
v-lili6-msft
Community Support
Community Support
‎04-13-2021 11:46 PM

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
Frequent Visitor
‎04-19-2021 11:58 PM

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. 

Idea Statuses