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

Can you provide a screenshot of the interface where the "+ Insert" button is not visible?

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

  • aj1973's avatar
    aj1973
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi RobRayborn 
    Please check out my reply  6 and give it a try. You need to contact the Power BI Admin and verify with him.

     

  • 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

       

      • 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

         

  • gcperez's avatar
    gcperez
    Regular Visitor
    2 years ago

    Hi, I am having the same exact issue here. I hace checked everything and the option "+ Insert Table" still not showing. Could It be that Microsoft is still rolling out this capability.

     

    Best regards