Problemas al consultar datos en tableros con Power BI Services fuente de dato Analysis Services

[mcdbrito68]

Desarrollé tableros en power BI desktop con conexión a Analysis Services, que funcionan bien, con un usuario del dominio, posteriormente configuré el Getway y logré la conexión al servidor de Analysis Services y a Databases, no me presente problemas, pero cuando trato de publicar el tablero no logra acceder a los datos del Cubo de la databases, ya configuré paso a paso como se debe de realizar, utilizo una versión PREMIUM de Power BI.

Si logro establecer comunicación con el servidor de Analysis Services.

Si está haciendo la actualización de la información del cubo.

Pero cuando quiero publicar, todo va bien pero no tiene acceso a los datos:

Me marca ese error y no he podido quitarselo.

[lbendlin]

The connection owner on the gateway's connection definition must be SSAS cube admin  (have DISCOVER permissions).  Unbelievable but true.

[mcdbrito68]

Yes, the same user manages everything: the one who manages the gateway, the owner of the Power BI desktop file, and the pubishing account.  In short, it´s all the same user.  Thank you form your attention.

[lbendlin]

Those things are not important. The connection owner on the gateway's connection definition must be SSAS cube admin  (have DISCOVER permissions). 

[mcdbrito68]

I show you from Visual Studio how to configure the roles: 

This is the domain user who does everything even if it is not important:

I don't know what else I should configure, I keep getting the same error.

[lbendlin]

That very first checkbox needs to be checked.

[mcdbrito68]

Yes, I've also checked it along with the other two boxes, but the result is the same. Regards

[v-menakakota]

Hi @mcdbrito68 ,
Thank you for bringing your query to the Microsoft Fabric Community Forum.

Please go through the solved issue which may help you in resolving the issue
Solved: DataSource.Error: AnalysisServices: Response statu... - Microsoft Fabric Community

If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.

[mcdbrito68]

I'm still having the same issue when I deploy the Power BI dashboard to publish it. It doesn't allow access to the data in Analysis Services. I've already checked the proxy and cube settings in Visual Studio, and everything is fine.

[v-menakakota]

Hi  @mcdbrito68  ,

Since the configuration seems correct (including SSAS roles, gateway connection, and publishing steps), and the problem persists despite all recommended checks, I recommend raising a Microsoft Support ticket for a deeper analysis.

Please refer below link on how to raise a contact support or support ticket. 
How to create a Fabric and Power BI Support ticket - Power BI | Microsoft Learn 

Best Regards, 
Menaka.
Community Support Team 

[v-menakakota]

Hi @mcdbrito68 ,

We are following up once again regarding your query. Could you please confirm if the issue has been resolved through the support ticket with Microsoft?

If the issue has been resolved, we kindly request you to share the resolution or key insights here to help others in the community. If we don’t hear back, we’ll go ahead and close this thread.

Should you need further assistance in the future, we encourage you to reach out via the Microsoft Fabric Community Forum and create a new thread. We’ll be happy to help.

Thank you for your understanding and participation.

[mcdbrito68]

I'm still having the same issue when I deploy the Power BI dashboard to publish it. It doesn't allow access to the data in Analysis Services. I've already checked the proxy and cube settings in Visual Studio, and everything is fine.

[v-menakakota]

Hi @mcdbrito68 ,

Did you get a chance to raise a support ticket? The support team can investigate the issue further on the backend. If you’ve already submitted one, please wait for their response.

Thank you.

[v-menakakota]

Hi @mcdbrito68 ,

Can you please confirm, did you get a chance to raise a support ticket? The support team can investigate the issue further on the backend. If you’ve already submitted one, please wait for their response.

Thank you.

[mcdbrito68]

Levante un ticket  

Problems accessing Analysis Services 2022 information from Power BI services

They don´t answer me anything

[v-menakakota]

Hi @mcdbrito68 ,

Apologies for the inconvenience, could you please share the Support Ticket number.

Best Regards, 
Community Support Team.