Forum Discussion

Phillipe_soares's avatar
Phillipe_soares
Frequent Visitor
4 years ago

Dataset with connected dataflow

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 increm...
Dataflow
Anonymous's avatar
Anonymous
Not applicable
4 years ago

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/2296121

 

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's avatar
    Phillipe_soares
    Frequent Visitor
    3 years ago

    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?