Refreshing and saving dataflows failing for two days now

[Juha]

Hi,

I am managing a workspace in Power BI which has a number of dataflows. These dataflows have been working as expected until Sunday October 24th when all scheduled refreshes failed after 24 hours of processing. Typical refresh times are between couple of minutes to half an hour. Manually triggered refreshes are not getting completed either. When trying to modify a dataflow or to create a new one saving changes fails. There seems to be nothing mentioned regarding this in service status, so I assume this issue is specific to my workspace. Any idea what might be causing this and how I could resolve it? Thank you.

[Juha]

I noticed that even though the refresh attempts result in a failure message after 24 h period, new records have been added to the data. Also the changes made are saved despite the error message.

[JGroothedde]

I had the same issue in Power BI Desktop with one addition: when trying to save a report i got the errormessage 'Invoke attempt failed'. 

I 'solved' it by installing the August 2021 version of Power BI.

[Juha]

My problem concerns Power BI Service, so the Desktop version has no impact here.

[JGroothedde]

Ah excuse me, that makes sense.

[v-robertq-msft]

Hi,

According to my research, here are some related ICM about this issue, what the kind of your data source?

ICM: 267631884

This is an issue with Snowflake ODBC driver.

Best Regards,

Community Support Team _Robert Qin

[Juha]

This happens with all data sources: I mostly use Azure SQL server, but the same thing happens with a local Excel file as well. Dataflow refresh returns an error "Cannot acquire lock for model" and modifying an existing dataflow and trying to save changes returns “can’t save dataflow: unknown exception”.