Forum Discussion
PBI Report - Windows Authentication "As User Viewing the report" Import mode
Ok, let me explain something:
1.- The image you posted before when connecting to SQL Analisys Services is always "live connection" never imports the data. In this case you have to configure the permissions on the Analisys Sevices model Security tab.
2.- When your report is used in "import mode" connected to a SQL Database or Excel file or any source that can be used in import mode and the user is not a server (or specific folder) administrator, no other user can see the credentials you are writting down on the scheduled refresh tab. Then there is no risk that anyone can see them. On top of that, if you have created an specific user in the domain with read-only privileges on the database, I see no point so avoin entering user-password on the report refresh.
In other words, when you have an import-mode connection and you want scheduled refreshes you NEED to introduce credentials for this....
Regards,
Hi,
With import mode, the best solution will be to use RLS or Row Level Security, that is implemented on the Server.
You will need to configure your .pbix with the necessary "roles" and, later in the server you will have to assign domain users to roles....
You can test in the pbix how every role will behave before implementing.
I suggest you to save the report with a different name or test first in a different folder.
Roles and user matching shall be a bit tricky at the begining until you get used to it.....
I hope it will help you...
Hi,
thank you, I tried configuring roles and it seems to be a good solution for viewing the report.
Unfortunally I also want to refresh the report with windows authentication but without specifing username and password explicitly.
Do you know if that is even possible for import mode?
Setting the datarole does not seem to be enough, when I try to create a refresh plan I get an error message about missing credentials.
