Power BI Report Builder SSAS paginated report

[Anonymous]

Hi, I'm trying to replicate the steps of this video:

https://www.youtube.com/watch?v=2G4P6L_A7oo&t=262s

Since that is what I have to do exactly, the problem arises when I try to connect with the Power BI workspace API.

I do not see the SSAS data sets that I have in the work area.

I try to make a connection test but error goes out.

It is possible that it is a mistake of credentials, but I have also tried.

any ideas?

[v-qiuyu-msft]

Hi @Anonymous, 

Access to XMLA endpoints is available for datasets in Power BI Premium. In your scenario, please ensure you copy the workspace connection from a premium workspace. When you use this URL as SSAS server name in Power BI report builder, it will prompt you enter the credential, please type your Power BI service account which has access to this premium workspace. For more information, please refer to this blog: https://powerbi.microsoft.com/en-us/blog/power-bi-open-platform-connectivity-with-xmla-endpoints-public-preview/

Best Regards,
Qiuyun Yu