Dataset with connected dataflow

[Phillipe_soares]

Hello, I have a dataset where I connect several configured data streams. My flows work correctly, it is working with incremental update in the power bi service, my problem is in PBIX, where an incremental update is not being configured in this dataset.
How do I close the update queries is incremental, dataset taking 1 hour to update, theoretically it should update in 5 minutes, as all connections are almost in data streams.
Already my model and analysis unimportant.
Does anyone know how I can get this setting right?

[Phillipe_soares]

Hello @Anonymous 
sorry for the delay in responding,
In case it didn't solve it, even doing this procedure, it returns another error in the dataset.

Error below:

Data source error: {"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 did not match any row in the table."}},{"code":"DM_ErrorDetailNameCode_UnderlyingHResult","detail":{"type":1,"value":"-2147467259"}},{" code":"Microsoft.Data.Mashup.ValueError.Key","detail":{"type":1,"value":"[workspaceId = \"c51f16c1-4df4-4b25-a60a-c4232e9a11f0\"]"} },{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail":{"type":1,"value":"Expression.Error"}},{"code":"Microsoft. Data.Mashup.ValueError.Table","detail":{"type":1,"value":"#table({\"workspaceId\", \"workspaceName\", \"workspaceType\", \"Tags \", \"Data\", \"ItemKind\", \"ItemName\", \"IsLeaf\"}, {})"}}],"exceptionCulprit":1}}}

When I disable the incremental update option, it updates normally.
Can you help me?

[Anonymous]

Hi @Phillipe_soares ,

Refer to the following steps to remove the incremental refresh strategy and then update the model：
1.Open the model in the Tabular editor and save the .bim file
2.Again open tabular editor and open the .bim file from the local and deleted the tables with IR policy
3.Deployed the .bim file to service via tabular editor (So at this stage the IR tables are deleted from service)
4.Published the new model file by overwriting the exisiting model via tabular editor.

A similar solution can be found below：https://community.powerbi.com/t5/Service/Remove-incremental-refresh-from-the-existing-table/m-p/2296...

If the problem is still not resolved, please provide detailed error information and related operation screenshoots. Looking forward to your reply.

Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Phillipe_soares]

Hello @Anonymous 
sorry for the delay in responding,
if it has not resolved, even doing this procedure, it returns another error in the dataset.

Error below:

type":1,"value":"[workspaceId = \"c51f16c1-4df4-4b25-a60a-c4232e9a11f0\"]"} },{"code":"Microsoft.Data.Mashup.ValueError.Reason","detail ":{"type":1,"value":"Expression.Error"}},{"code":"Microsoft. Data.Mashup.ValueError.Table","detail":{"type":1,"value":"#table({\"workspaceId\", \"workspaceName\", \"workspaceType\", \"Tags \", \"Data\", \"ItemKind\", \"ItemName\", \"IsLeaf\"}, {})"}}],,"exceptionCulprit":1}}} type":1, "value":"Expression.Error"}},{"code":"Microsoft. Data.Mashup.ValueError.Table","detail":{"type":1,"value":"#table({\ "workspaceId\", \"workspaceName\", \"workspaceType\", \"Tags\", \"Data\", \"ItemKind\", \"ItemName\", \"IsLeaf\"}, {} )"}}],,"exceptionCulprit":1}}} type":1,"value":"Expression.Error"}},{"code":"Microsoft. Data.Mashup.ValueError.Table","detail":{"type":1,"value":"#table({\"workspaceId\", \"workspaceName\", \"workspaceType\", \"Tags \", \"Data\", \"ItemKind\", \"ItemName\", \"IsLeaf\"}, {})"}}],,"exceptionCulprit":1}}}

When I disable the incremental update option, it updates normally.
Can you help me?