Dataflow refresh error while works in pbix: SOLUTION

Hi

I created a pbix with some tables from a Dataflow.

While it refreshed in PBI Desktop, the online refresh kept stopping with an error.

After trying many suggested solutions here, the solution for me is very simple:

In the code the source of the table is:

= #"da944968-62f2-428........."{[entity="Tablename",version=""]}[Data]

>>After I removed ,version = "" all is refreshing like a charm

The error at online refresh for your reference

 {

"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":"[entity = \"Dataflow-TableName", version = \"\"]"}},{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}},{"code":"Microsoft.Data.Mashup.ValueError.Table","detail":{"type":1,"value":"#table({\"entity\", \"dataCategory\", \"Data\", \"Tags\", \"ItemKind\", \"ItemName\", \"IsLeaf\"}, {})"}}],"exceptionCulprit":1}}} 

Table: depending table.

URI cluster: WABI-WEST-EUROPE-D-PRIMARY-redirect.analysis.windows.net

Activiteits-id: df70866e-2642-4a2b-a130-7.......

Aanvraag-id: 47ec1c1f-f25d-44ce-8.........

Tijd: 2024-12-18 16:34:40Z