topic Connection Mode for Embed PBI on SSAS in Report Server

Connection Mode for Embed PBI on SSAS

gcrest — Mon, 08 Jan 2018 16:37:18 GMT

Hello,

I'm having an issue when trying to embed PBI reports in my own webpage. These reports are based on SSAS data.

I wish my users - who are connected on my webpage - don't have to authenticate again on RS.
Those users are not known by our LDAP network, we have therefore created a generic authorized service account.
The idea is to set the user credentials (ID & Pwd) via the authorization http header.
To do this, I change the connection mode from RSWindowsNTLM to RSWindowsBasic, this is what I get :
- RS is connected with the generic user => OK
- the report elements are displayed => OK
- but no data is displayed => KO.

The test to the datasource with this generic user was succesful in the report management page.

I get this message in french : "Impossible de charger le modèle" that could be translated into "Failed to load the model".

We're using the latest October version.
Could you help me on that subject?

Best regards

Re: Connection Mode for Embed PBI on SSAS

v-yulgu-msft — Thu, 11 Jan 2018 01:58:19 GMT

Hi @gcrest,

Did you grant PBI Report Server access permission to your generic user account?

Regards,

Yuliana Gu

Re: Connection Mode for Embed PBI on SSAS

gcrest — Thu, 11 Jan 2018 09:07:37 GMT

Hello,

Thank you for your reply,

Yes the generic user is granted on the PBI server.

The problem seems to be more on the SSAS data than on the server, don't you think ?

I read this message https://community.powerbi.com/t5/Report-Server/Powerbi-report-server-custom-authentication-adding-machineKey/td-p/308872 and wondered if this was not the same problem.

Do you know if this precise bug will be resolved in the next version ?

Regards

Re: Connection Mode for Embed PBI on SSAS

gcrest — Thu, 11 Jan 2018 10:09:11 GMT

Hello again Yuliana,

Just one precision : we're currently using the 2016 developper SqlServer version.

I don't know if this would change anything with the 2017 and\or enterprise version.

Best regards,

Guillaume

Re: Connection Mode for Embed PBI on SSAS

gcrest — Fri, 12 Jan 2018 13:13:47 GMT

Hello Yuliana,

As I wrote previsously I used the october version, that was released at the beginning of November.

But I realised one the changelog page that the november version contained a "Fix for Basic Authentication Scenarios".

With this hotfix it now seems to perfectly work.

Thx for your help,

Best regards,

Guillaume