Find the Insert Table Option for Power BI Data in Excel
Question details
The user wants to locate the Insert Table command when using an Excel connection to a Power BI dataset.
- Product
- Microsoft Excel for Microsoft 365 with Power BI datasets
- Device & OS
- not provided
- Scenario
- The user is connected to or can access a Power BI dataset in Excel and wants to insert a regular table from that data.
- Observed behavior
- The Insert Table option is missing, while Insert PivotTable may be available.
Confirm that you are signed in to Excel with the account that has permission to access the Power BI dataset. Check whether Insert PivotTable works first, because it indicates that the Power BI connection is generally configured correctly.
Check the Microsoft 365 update channel and update Excel
Use this when the Power BI connection works but the Insert Table command is unavailable in Excel.
The availability of Insert Table for Power BI data can depend on the Microsoft 365 update channel and the staged feature rollout for your Excel build. Current Channel users may receive both Insert Table and Insert PivotTable without enabling an extra setting.
In Excel, select File > Account, then review the information under Product Information and About Excel to identify your installed version and update channel.
Select File > Account > Update Options > Update Now, then allow Excel and Microsoft 365 to install any available updates.
Close and reopen Excel, reconnect to the Power BI dataset, and check the Insert tab or the Power BI dataset insertion options for Insert Table.
If Excel is fully updated but Insert Table is still absent, the feature may not yet be enabled for your update channel or tenant. Continue using Insert PivotTable where available.
Use Insert PivotTable when table insertion is not available
Use this as a practical workaround when your Excel build offers Power BI PivotTable insertion but not Insert Table.
Use WPS Office for everyday Excel-compatible spreadsheet work
The missing Insert Table command is controlled by Microsoft Excel and Power BI feature availability, so WPS Office cannot enable it. For everyday spreadsheet creation, editing, import, export, and collaboration, WPS Office provides a free, lightweight alternative with a familiar interface and seamless migration for common Office files.
Frequently Asked Questions
Why does Excel show Insert PivotTable but not Insert Table for my Power BI dataset?
The commands can be released separately based on your Microsoft 365 update channel, Excel build, and staged rollout status. If Insert PivotTable works, your dataset connection and permissions are generally working.
Where can I check my Microsoft 365 update channel in Excel?
Open Excel and select File > Account. Under Product Information or About Excel, review the version details and the update channel listed for your installation.
Do I need to enable a special setting to use Insert Table with Power BI data?
Usually no additional setting is required when the feature is available to your Microsoft 365 build. Update Excel through File > Account > Update Options > Update Now and check again after restarting the app.
Can I still analyze a Power BI dataset if Insert Table is missing?
Yes. Use Insert > PivotTable and select the Power BI dataset or available connection. You can add fields to Rows, Columns, Values, and Filters to analyze the dataset in a PivotTable.
Will changing to Current Channel immediately add Insert Table?
Not always. Current Channel can receive features sooner, but availability can still depend on Microsoft’s rollout schedule and your organization’s Microsoft 365 update policies.
