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
pmreis's avatar
pmreis
Icon for Most Valuable Professional rankMost 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
Icon for Helper IV rankHelper 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
    Icon for Community Champion rankCommunity Champion
    2 years ago

    Hi RobRayborn 

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

     

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

    Can you confirm this happens in Excel Desktop?