Authenticaton Power BI Dataset in Power BI Report Server
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?
