Hi,

I originally posted this question in the Power BI Community forum, where it was suggested I ask it here:

We are analyzing a Power BI Data Set via the "Analyze in Excel" option. We download the odc.-file and open it in Excel.
For the connection properties, we have set "Always use connection file", "Save password" and "Refresh data when opening file" options.
We intend the file to be used by multiple people, so the credentials need to be saved and the data should always refresh when the file is opened.
This works fine if only a single user is using the Excel file. Whenever a second user opens the file, the "Refresh data when opening file" option seems to become unchecked and the file stops updating.

Is anyone experiencing a similar behaviour? Or does anyone have a solution / workaround?

Thanks!