Forum Discussion

JacobIsbell's avatar
JacobIsbell
Icon for Advocate I rankAdvocate I
9 years ago
Solved

Can free users use "Analyze in Excel" functionality if ODC is shared from a Pro user?

I'd like to be able to share the models I build and publish to the PowerBI.com service with free license-level users in our organization by sending them the ODC file.   Is this possible or will thi...
  • Anonymous's avatar
    Anonymous
    9 years ago

    Hi JacobIsbell,

    Yes, as long as you don't contain Power BI pro content in dashboard, your shared users don't require pro license and they are able  to use "Analyze in Excel" feature.

    Thanks,
    Lydia Zhang

Anonymous's avatar
Anonymous
Not applicable
9 years ago

JacobIsbell Whew... I've never walked through this scenerio... If I read things correctly the end user would need to have access to the dataset in Power BI... Whether that means it is shared with them via a dashboard, or if they actually need access to the dataset I don't know. If they need access to the dataset it would need to be in a Group Workspace or Org Content Pack both of which would require a Pro license... I would test this out, but my initial assumption is that it won't work.

JacobIsbell's avatar
JacobIsbell
Icon for Advocate I rankAdvocate I
9 years ago

Anonymous That's what I was thinking too. I doubt MS wants 10 thousand free licensed people to be able to access a model through an ODC Excel connection without capitalizing on that. I guess I'll keep pursuing a full test just to be sure.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi JacobIsbell,

    Based on IlanH’s comment in this thread, “Analyze in Excel” feature is available and working for Power BI free users. However, "Analyze in Excel" has limitation that it doesn't work for "on premise analysis services" dataset at that time. 


    I just test the scenario that firstly connecting to SSAS cube using import mode in Power BI Deskstop, publishing report to Service and sharing a dashboard to a free user, everything works well, you can also test it in your environment.  But when you connect to SSAS cube using Live connection(Gateway is required) mode, your shared users should have pro licenses as you contain pro content in the dashboard.


    Thanks,
    Lydia Zhang

    • JacobIsbell's avatar
      JacobIsbell
      Icon for Advocate I rankAdvocate I
      9 years ago

      Thanks for the reply, Anonymous. In this particular use case, the source data will be flat structures that I'm importing into Power BI (no connection live or otherwise to a cube or other data source) so I'm assuming this will still work since there will be no live connections. Is my logic sound?

       

      Thanks!

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi JacobIsbell,

        Yes, as long as you don't contain Power BI pro content in dashboard, your shared users don't require pro license and they are able  to use "Analyze in Excel" feature.

        Thanks,
        Lydia Zhang