Forum Discussion

DidacBF's avatar
DidacBF
Frequent Visitor
2 years ago

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...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

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.

DidacBF's avatar
DidacBF
Frequent Visitor
2 years ago

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.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    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.

     

     

    • DidacBF's avatar
      DidacBF
      Frequent Visitor
      2 years ago

      Hi Anonymous 

      That's what I meant yes! 
      I'm on this version (desktop):


      Not sure how to get PBI service one.


      Today the problem solved itself just by reconnecting the report to it's semantic model again, It didn't work yesterday.

      But I am still unable to upload it to service:

       

      I don't know why because it doens't give me any context at all...


      Just so you know, we are working with GIT (preview pbip Powerbi Projects). If I save it as .pbix then I can upload it. Maybe it has something to do about being in preview but it didn't happen before and I don't know how to report the issue if needed.

      Thank you!


      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi DidacBF ,

        I'll report the problem. Please bear with me. Thank you

        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.