Forum Discussion

RobRayborn's avatar
RobRayborn
Helper 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
RobRayborn's avatar
RobRayborn
Helper IV
2 years ago

Microsoft® Excel® for Microsoft 365 MSO (Version 2309 Build 16.0.16827.20278) 64-bit

mattiasdesmet's avatar
mattiasdesmet
Resolver II
2 years ago

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

  • RobRayborn's avatar
    RobRayborn
    Helper IV
    2 years ago

    • aj1973's avatar
      aj1973
      Community 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
      Resolver 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

    • 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