Users unable to insert table in excel from semantic model

[jconte12]

Hello,

I have created a fairly large semantic model in power bi. My users are all very excel savvy. We have been using the get data and inserting a pivot table. The issue I am currently facing is, I have access to the insert table, but the folks I shared it with do not have access to it. Is this a licensing issues, or do I need to change their access level in the workspace?

I don't want the users to be able to modify the core dataset, but I want them to be able to select the fields they need, instead of only having access to a pivot table. As of now, the users have Read and Share permissions -- would build access change this?

[Gayatri_D05 · Accepted solution]

Hi! Its mandatory that have at least a Contributor role in the Power BI workspace containing your semantic model.
Also dont forget for newly created semantic models, recently refreshed semantic models, or semantic models that you just got access to, it may take up to 24 hours for these semantic models to show up in the Power BI Semantic models pane.
The users would have to check after 24 hours if they are able to access it.

I hope I was able to resolve your issue. If so please mark it so it can help others as well. 😊

[Gayatri_D05 · Accepted solution]

Hi @jconte12 Another quick option you can check if users would like to work with is Analyze in Excel for whichever report that they want to use.

[Gayatri_D05]

Hi @jconte12 ,
This is an issue I personally faced too.
So to answer you question, Firstly yes you would need to give them the access to the report/dataset.
And second one of the cons is for the users to be able to see this dataset in the excel they would have to atleast wait for 24 hours for it to reflect in the list.
Please refer to the 4th point : https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-connect-excel-power-bi-datasets...

I hope I was able to resolve your issue. If so please tag this as the answer to help others as well. 😊

[jconte12]

Hi!

Thank you for your response! What level of access is required? Read and Build? They currently have Read and Build and aren't seeing it. If I give them modify, would that resolve it?

[Gayatri_D05 · Accepted solution]

Hi! Its mandatory that have at least a Contributor role in the Power BI workspace containing your semantic model.
Also dont forget for newly created semantic models, recently refreshed semantic models, or semantic models that you just got access to, it may take up to 24 hours for these semantic models to show up in the Power BI Semantic models pane.
The users would have to check after 24 hours if they are able to access it.

I hope I was able to resolve your issue. If so please mark it so it can help others as well. 😊