You do not have permissions to the underlying external semantic model

[Humayun4312]

I have made a Power BI report and publish it to a PPU workspace. I am admin of workspace and I have enabled XMLA endpoint as Read Write in Admin Settings. I have downloaded the same report from Power BI service with live connection to underlying data.

My report shows "Connected live to Power BI semantic mode: ABC".

I click on Make changes to this model.

I clicked Add a local model and selected the database and click submit button.

I am getting this error message.

How to resolve this error.

I want to edit the model and add one more table using the approch I discuss above.

I have similar issue in another workspace where report and sematic model is aslready published by someone else so I have reproduce the error this way. And I have all the amdin access there as well.

[Deku]

Do you have all the following enabled?

"

To enable the creation and consumption of composite models on Power BI semantic models, your tenant needs to have the following switches enabled:

• Allow XMLA Endpoints and Analyze in Excel with on-premises semantic models. If this switch is disabled a DirectQuery connection to a Power BI semantic model can't be made.
• Users can work with Power BI semantic models in Excel using a live connection. If this switch is disabled, users can't make live connections to Power BI semantic models so the Make changes to this model button can't be reached.
• Allow DirectQuery connection to Power BI semantic models. See the following paragraphs for more information on this switch and the effect of disabling it.

Additionally, for Premium capacities and Premium Per User the "XMLA endpoint" setting should be enabled and set to to either "Read Only" or "Read/Write".

"

https://learn.microsoft.com/en-us/power-bi/transform-model/desktop-composite-models#managing-composi...

[Humayun4312]

The Power BI Admin settings you mentioned are enabled for the entire organization.

XMLA endpoint setting is set to Read Write.

[Deku]

Just noticed it says external data model on the error, are you trying to connect to a model in another tenant?

[Humayun4312]

No. Tenant is same.

Following are the steps to reproduce the error:

1. Create a simple report and upload it to Power BI service.

2. Download the same report with live connection to dataset. 

3. Then procced through the steps for "Make changes to this model". It should give you error in 2nd or 3rd step.

[Hariharan_R]

Hi @Humayun4312 

I am able to reproduce the error. 

Follow the below steps to fix.

1. Go to Transform Data -> Data source settings

2. choose your semantic model again and click connect

3. click "make changes to the model" then you should be able to convert to direct query

Thanks

Hari

Please mark this as a solution if these steps solves your issue.