Forum Discussion
User login into Report Server On premises
I have setup Report Server on my PC (WIN 10) with SQL Server Evaluation Version . I was able to access Report Server URL and also create sample .pbix and publish it to Report server. I want to ...
For those coming much after this question was asked, my experience was that I needed to add the users (or groups) to SQL server security, so that requests could be checked for permissions to perform the operation requested. Think: user -> PBIRS -> SQL Server -> Active Directory. If a user is not in SQL Server security, his/her request will not be passed on to AD for a check of permissions. I created an AD group called PowerBI, and gave that group needed permissions in SQL server. You can add groups for Publisher to AD, and add people to that group, and use that group membership within the PowerBI Report Server, to grant them the right to publish reports.
Roger