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
pmreis's avatar
pmreis
Most Valuable Professional
2 years ago

Hi RobRayborn 

 

  1. Open Excel on Desktop.
  2. Get data from PowerPlatform.
  3. You will have the option to create a Table or Pivot table.

 


Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple

If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!

Find me at LinkedIn
  • RobRayborn's avatar
    RobRayborn
    Helper IV
    2 years ago

    This did not fix the problem. 
    I'm only allowed to pull in a Dataset and use it as a Pivot Table. + Insert Table is not an option that is available.

    • aj1973's avatar
      aj1973
      Community Champion
      2 years ago

      Hi RobRayborn 

      This is an edit permission reason that needs to be allowed from the tenant

       

    • mattiasdesmet's avatar
      mattiasdesmet
      Resolver II
      2 years ago

      Can you confirm this happens in Excel Desktop?