Forum Discussion

RobertSlattery's avatar
RobertSlattery
Responsive Resident
4 years ago
Solved

Error when Save and Close dataflow

After editing a dataflow, I get an error when I try to "Save and Close". My scenario is when I edit a query that has been set for incrimental refresh.  I edit it to pass the range params to a custom...
Dataflow
  • RobertSlattery's avatar
    RobertSlattery
    4 years ago

    Thanks for the suggestions, unfortunately they didn't help.  I managed to solve the problem mysef by changing the proceedure I followed.  After I uncomment the line

    Source = ODBC_BLP800CFBL(SalesOrdersSQL,RangeStart, RangeEnd),

     I also delete 

     

    #"SalesOrders-44415445-autogenerated_for_incremental_refresh" = ...

     

     I then save the dataflow and this last line is re-inserted automatically.

v-zhangti's avatar
v-zhangti
Community Support
4 years ago

Hi, RobertSlattery 

 

Please refer to the following post, hope it can help you.

https://community.powerbi.com/t5/Power-Query/DataFlow-does-not-save-due-to-dynamic-data-source/m-p/2269582 

https://community.powerbi.com/t5/Service/Can-t-save-dataflow-cannot-acquire-lock-for-model/m-p/818574 

https://community.powerbi.com/t5/Service/Cannot-refresh-or-save-dataflow-Cannot-acquire-lock-for-model/m-p/888031 

https://community.powerbi.com/t5/Service/Can-t-save-dataflow-Unknown-exception/m-p/2033530 

 

Best Regards,

Community Support Team _Charlotte

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

  • RobertSlattery's avatar
    RobertSlattery
    Responsive Resident
    4 years ago

    Thanks for the suggestions, unfortunately they didn't help.  I managed to solve the problem mysef by changing the proceedure I followed.  After I uncomment the line

    Source = ODBC_BLP800CFBL(SalesOrdersSQL,RangeStart, RangeEnd),

     I also delete 

     

    #"SalesOrders-44415445-autogenerated_for_incremental_refresh" = ...

     

     I then save the dataflow and this last line is re-inserted automatically.