Power BI Dataset and Excel

[RobRayborn]

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?

[tvanstraelen]

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.

[mattiasdesmet]

Could it be that it is not rolled out to you yet:

Announcing new ways to create connected tables in Excel connected to Power BI | Microsoft Power BI B...

Is your excel version great than 16.0.15427.10000? (file, account, about)

E.g. Monthly enterprise channel doesnt seem to have it, etc...

[RobRayborn]

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

[mattiasdesmet]

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

[RobRayborn]

[gcperez]

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

[mattiasdesmet]

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]

[mattiasdesmet]

Also check that you have Build permissions on the PowerBI dataset/semantic model: 

... -> Manage Permissions -> Direct access -> your user/group

[aj1973]

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.

[RobRayborn]

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.

[pmreis]

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]

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.

[mattiasdesmet]

Can you confirm this happens in Excel Desktop?

[aj1973]

Hi @RobRayborn 

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

[mattiasdesmet]

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?

[RobRayborn]

I receive only the option of Insert Pivot table in both.