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

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