Unable to configure data connection in Power BI Service for my workspace

[vasum]

Hi, I am trying to publish a Power BI dashboard and enable regular refresh using an on-premise data gateway. While creating the new connection pointing to the analysis service, I am getting the following error (from the log file) (I have removed actual user name from the message below)

GatewayPipelineErrorCode=DM_GWPipeline_UnknownError
GatewayVersion=
InnerType=AdomdErrorResponseException
InnerMessage=<ccon>The 'XXXX' user does not have permission to call the Discover method.</ccon>
InnerToString=<ccon>Microsoft.AnalysisServices.AdomdClient.AdomdErrorResponseException: The 'XXXX' user does not have permission to call the Discover method.
at Microsoft.AnalysisServices.AdomdClient.XmlaClient.CheckForException(XmlReader reader, XmlaResult xmlaResult, Boolean throwIfError) 

 This is the last step in getting an important Power BI report published and regularly updated.
Also to confirm, I am able to access the analysis services without any issues from Power BI desktop.

Please can you advise what is going on here and a resolution please?

[lbendlin · Accepted solution]

The gateway connection user must be cube admin.  Yes, shocking.  But according to Patrick LeBlanc that is by design, and there are no plans to change that requirement.

[v-sgandrathi · Accepted solution]

Hi @vasum,
Thank you for reaching out to the Microsoft Fabric Community forum.

The error occurs because the user account specified in the on-premises data gateway configuration does not have the required permissions in SQL Server Analysis Services (SSAS) to execute the Discover method.

The user responsible for the on-premises data gateway connection must possess cube administrator permissions in SQL Server Analysis Services (SSAS) to ensure proper functionality with Power BI Service.

Patrick LeBlanc's statement is accurate: cube admin permission is required, and there are currently no plans to reduce this requirement.

If this post clears your doubt, please give us Kudos and consider marking Accepting it as a solution to guide other members in finding it more easily.

Regards,
Sahasra.

[v-sgandrathi]

Hi @vasum,

May I ask if you have gotten this issue resolved?

If it is solved, please mark the helpful reply or share your solution and accept it as solution, it will be helpful for other members of the community who have similar problems as yours to solve it faster.

Thank you for being a part of the Microsoft Fabric Community.

[v-sgandrathi]

Hi @vasum,

we haven't heard back from you regarding our last response and wanted to check if your issue has been resolved.

If our response addressed by the community member for  your query, please mark it as Accept Answer and click Yes if you found it helpful.

Should you have any further questions, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community Forum!

[v-sgandrathi]

Hi @vasum,

We wanted to follow up since we haven't heard back from you regarding our last response. We hope your issue has been resolved.

If my answer resolved your query, please mark it as "Accept Answer" and select "Yes" if it was helpful.

If you need any further assistance, feel free to reach out.

Thank you for being a part of the Microsoft Fabric Community!

[lbendlin · Accepted solution]

The gateway connection user must be cube admin.  Yes, shocking.  But according to Patrick LeBlanc that is by design, and there are no plans to change that requirement.