Unable to insert table for some Power BI datasets in Excel

Hi fo6168 

Thanks for the reply from AnkitKukreja and pallavi_r .

If the problem persists, then it may be necessary for you to provide more information so that we can better assist you. From your screenshot, it looks like the two semantic models are not from the same workspace, so are both workspaces from the same tenant? Also, from your screenshot it looks like table does not exist in that dataset, what is your role in that workspace? You may need to check the settings related to this semantic model.

After testing, the “Insert Table” option is grayed out when I don't have the following option turned on in the admin portal. During my testing, this error occurs only in this case, please check again.

Also, you need to have a Fabric license and Fabric administrator role to access the admin portal, if you don't meet this condition then you may need to contact your organization's administrator.

For more details, you can read related documents:

What is the Microsoft Fabric admin portal? - Microsoft Fabric | Microsoft Learn

What is Microsoft Fabric administration? - Microsoft Fabric | Microsoft Learn

There is another point that I am questioning, in the last year Power BI Dataset has been renamed to Power BI Semantic model as shown in the screenshot I have provided, but your screenshot still shows Power BI Dataset, I think you can also check the current version of Power BI.

New name for Power BI datasets - Power BI | Microsoft Learn

Best Regards,
Yulia Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.