Authenticaton Power BI Dataset in Power BI Report Server

[Paulien_]

Hi,

I am currently working on a solution which looks like the following:

1. We build a data model in Power BI Desktop and uploaded it to the Power BI Service in a Premium workspace.

2. We would like to add this dataset as a shared dataset in the Power BI Report server. Therefore, we added a data source with type "Microsoft SQL Azure Analysis Services" and set the connectionstring accordingly.

The next step is authentication. The following options are available:


We don't want the user to login every time they want to view the report (they already had to log in to the server).  We also don't want to create a master account to use the option "Using the following credentials". Currently, it seems to me that the option "as the user viewing the report" seems the right one to choose. However, when I select this option I get the following error message: 

Is there any way we can resolve this error? If not, is there any way to show the reports to the user without a prompt to log in and without using a master account?

[AbhiSSRS]

You may need to enable SSO in Azure for this : https://docs.microsoft.com/en-us/power-bi/connect-data/service-azure-sql-database-with-direct-connec...

[v-henryk-mstf]

Hi @Paulien_ ,

For a data source like SSAS,you need check if the service account(s) you're using for SSAS/EGW has "Read" permission on the AD user in acrtive directory. 

Because the LC mode as data source is set, the user must have access to the data source. or change the connection mode to import and try again.  

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.