Forum Discussion
It's possible that the "Allow Live Connection" option has been moved or renamed in the Power BI service. However, it's also possible that the option is no longer available.
In general, to enable live connections to shared datasets in Power BI Desktop, you need to have the "Allow external embedding and sharing of content" option enabled in your Power BI tenant settings. This option allows users to share reports, dashboards, and datasets with external users and embed them in external websites and applications.
If this option is not enabled, you may not be able to use live connections to shared datasets in Power BI Desktop. However, you can still use import mode to connect to the shared datasets and refresh them manually or on a schedule.
Regarding your specific issue, if you don't want to enable "Users can work with Power BI datasets in Excel using a live connection" option in your tenant settings, you can try using a different approach to share your datasets. For example, you can create a workspace in Power BI and invite your colleagues to collaborate on it. You can then publish your dataset to this workspace and set up a scheduled refresh for it. Your colleagues can then connect to this dataset from their own Power BI Desktop and use import mode to work with it.
I hope this helps!