Forum Discussion
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 XuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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.
Hello v-xuxinyi-msft, thank you for your response, please see my corresponding answers below.
- In the screenshot I provided, there were 2 different semantic models in 2 different workspaces, but we only use a single tenant
- There are tables in the semantic model in my screenshot. I can see them in PBI online without an issue.
- I am an admin in the workspace where the semantic model exists.
- I am not able to view the admin settings at my company, but I will check with another member of my team to see if they can check the setting you highlighted above in your answer to see if that works.