Publishing error Google Sheets data

[jarod3477]

Hi,

I getting this error when publishing a report that is connected to Google Sheets: PowerBIInsufficientPermissionsOnProxyModelOrCompositeModelNotExistException

Any idea what this error means and how to resolve it?

Thank you!

Jarod

[v-jialongy-msft · Accepted solution]

@AmiraBedh  Thanks for your prompt reply! Please allow me to add some detailed instructions on how to do it.

Hi @jarod3477  The error typically indicates a permissions issue when trying to publish a report in Power BI that is connected to a composite model. To resolve this error, you should ensure that the user has the necessary permissions on both the dataset being used by the report (the “Base” dataset) and any composite models (the “Proxy” dataset) that reference the Base dataset.

Hope the following documents will help you solve your problem:
Setting the right permissions for users of composite models - SQLBI

Best Regards,

Jayleny

[AmiraBedh]

You need to verify that the account have the necessary permissions to publish reports using the proxy model.

Update to required permissions when using composite models on a Power BI dataset | Microsoft Power B...

To troubleshoot your error :

Troubleshoot Power BI Desktop publishing - Power BI | Microsoft Learn