Forum Discussion
Problem with setting "Users can work with Power BI semantic models in Excel using a live connection"
Hello,
I have a problem with an option in the administrator portal, this one:
I don't want users to have the option to connect to semantic models through Excel. However, if I disable this option, when I download a Report (made with powerbi, not excel) from the Service connected to a semantic model via live connection and I try to open it in the Desktop, it gives me the following error:
Does it make any sense? If so, does this mean that you cannot disable the option for users to access semantic models only through Excel?
Isn't this other option the one that should give me the error when disabled?
Thank you!
7 Replies
I want to second this. We do not want "Users can work with semantic models in Excel using a live connection", but disabling this option restrics "developers" from making a live connection in pbi desktop, not excel. Seems like a bug. Hope this can be fixed.
Hi Redriver123 do you have an update on this? If so how did you fix it? - I am experiencing the same issue...fffss
Hi DidacBF ,
If you have edit access to the report and has access to the underlying data source,you can download this pbix in Live Connection.
Below is the official link:
Export and sharing tenant settings - Microsoft Fabric | Microsoft Learn
Connect Excel to Power BI semantic models - Power BI | Microsoft Learn
To DirectQuery connections , the link will help you:
Manage DirectQuery connections to a published semantic model - Power BI | Microsoft Learn
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello Anonymous
I have both, edit and acces to the underlying data.
But I don't understand why this option is giving me problems with my reports with a live connection if the option is about Excel. I've never had any problems with live connection before.Thank you.
Hi DidacBF ,
I know what you mean, which means that as long as you turn this button off, all your Live Connection reports won't open, right?
I just tried it and found that after I turned that option off, I could still see the Live Connection report.
Maybe it's the version, the version I'm currently using is:13.0.22453.72
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
