Refresh in Power BI service gives errors

[haraldinti]

Refresh in Power BI service gives errors, while refresh in Power BI desktop goes well.

This worked well untill 14 days ago.

Power BI desktop and Data gateway are up-to-date.

Additional information:

The essence of the error is 'We cannot convert the value \"[Table]\" to type Table.' But in the mentioned table dimAdres is no convertion of tables.

Replacing the query with a plain Excel-import does not solve the problem either.

This is not about the query's, most of all because the query's work in desktop.

Who can help?

This is the full error:

An error occurred while processing the data in the dataset.

Error in data source:

{"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":"We cannot convert the value \"[Table]\" to type Table."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Value","detail":{"type":1,"value":"[Table]"}}],"exceptionCulprit":1}}}

Table: dimAdres

URI Cluster: WABI-WEST-EUROPE-redirect.analysis.windows.net

Activity ID: 12ba1427-c75a-43d6-b7f2-d06556f4c76f

Request ID: 2626b860-f1f5-454b-9988-ac47bb5dd84a

Time: 2024-11-21 13:08:38Z

{"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":"We cannot convert the value \"[Table]\" to type Table."}},{"code":"DM_Error

[Anonymous]

Thanks for GilbertQ's concern about this issue.

Hi, @haraldinti 

I am glad to help you.

DM_GWPipeline_Gateway_MashupDataAccessError usually indicates that there is a problem with the data gateway or data source connection in the Power BI service.

You can try restarting the data gateway. Sometimes, simply restarting the on-premise data gateway can resolve connection issues.

And you should make sure that the account running the Power BI On-premise Data Gateway has the necessary permissions to access the data source.

Since the error mentions conversion issues with the value “[Table]”, double check your query transformations in Power BI Desktop to ensure there are no implicit type conversions that might cause issues when published to the service

If the issue persists, consider uninstalling and reinstalling the On-premise Data Gateway.

I hope my suggestions give you good ideas, if you have any more questions, please clarify in a follow-up reply.
Best Regards,
Fen Ling,
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi @haraldinti 

This eric can often come about when there is a difference in the source data. I would suggest checking where you are getting the Excel file from that the source data hasn't changed, which is then affecting refresh in the power service if you. can get a successfully to refresh in the desktop. I would then also republish the file to the service to then see if it will successfully refresh it in the service after a republish.

[haraldinti]

Thanx for your reply GilbertQ. But this is what I tried several times and does not help.