Forum Discussion

RobRayborn's avatar
RobRayborn
Icon for Helper IV rankHelper IV
2 years ago

Power BI Dataset and Excel

I don't know if this is a Power BI issue or an Excel issue so I will post it in both forums.  When I try to import data from a Power BI Dataset I am not presented with the options of + Insert Pivot T...
Need Help
Tutorial Requests
mattiasdesmet's avatar
mattiasdesmet
Icon for Resolver II rankResolver II
2 years ago

Check your PowerBI tenant settings:

- tenant administrator must enable the Allow XMLA endpoints and Analyze in Excel with on-premises datasets tenant setting

- tenant administrator must enable the Users can work with Power BI semantic models in Excel using a live connection tenant setting

    • mattiasdesmet's avatar
      mattiasdesmet
      Icon for Resolver II rankResolver II
      2 years ago

      Also check that you have Build permissions on the PowerBI dataset/semantic model: 

      ... -> Manage Permissions -> Direct access -> your user/group