Forum Discussion
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 Table or + Insert Table. I'm only provided a list of Datasets available from our Work Spaces (Promoted and not Promoted) with the header that states, "Select a dataset to create a PivotTable. Your PivotTable will be created in a new worksheet." I have checked with our IT department and I have all the permissions necessary to be able to + Insert Table. I am also running Microsoft 365. Any ideas as to why this option is not available to me?
17 Replies
In Excel Online, you only get the option + Insert Pivot Table.
In the full Excel app on your laptop, you'll get both options +Insert Pivot Table + Insert Table
Is that the problem you encountered?
I receive only the option of Insert Pivot table in both.
Hi RobRayborn
- Open Excel on Desktop.
- Get data from PowerPlatform.
- 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 LinkedInThis 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.
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.Could it be that it is not rolled out to you yet:
Is your excel version great than 16.0.15427.10000? (file, account, about)
E.g. Monthly enterprise channel doesnt seem to have it, etc...
Microsoft® Excel® for Microsoft 365 MSO (Version 2309 Build 16.0.16827.20278) 64-bit
Can you provide a screenshot of the interface where the "+ Insert" button is not visible?
Also not (yet) seeing the option '+ Insert Tabel'.
All requirements are fullfilled (tenant settings, Excel version high enough, Build permissions on datasets).
I hope this option is available soon in all regions.
