"Insert table" option while connecting with Power BI dataset

Copper Contributor

Hi Team,

 

As per the update on August 23, 2023, excel was supposed to have new option of "Insert table" while connecting with Power BI dataset. Currently, it is able to connect option "Insert PivotTable" and not the other option "Insert table". Does anyone know how to activate that option or is it not rolled out yet for any one ?
The screenshot is attached and here is the blog link:
https://powerbi.microsoft.com/en-us/blog/announcing-new-ways-to-create-connected-tables-in-excel-con...

 

 

4 Replies

@happy30 

Perhaps availability depends on channel. I use it on Current channel, don't remember any additional setting are required, If Insert PivotTable worked before you shall have all proper settings for the Insert Table.

Yes, so Insert PivotTable option does work but "Insert table" option is not appearing as per screenshot shared. Can you please elaborate "Current channel" and are you able to view this option on your desktop ?
Thanks.

@happy30 

I'm on

image.png

and I have both

image.png

 

Thanks Sergi. I can see my version is 2308 and whereas yours is 2312. So may be it needs to update with this version.