Forum Discussion
Community Championon-premises gateway authentication
vanessafvg Yes it is true that stored credential will be used by the report to connect to data source except analysis services regardless of who is accessing the report but you have control over who the report / dashboard is shared with. Also you have option of implemeting row-level security in your data model and that will allow you to control over what level and amount of data is seen by which user of the report. Find out more about RLS here and using UPN function of DAX within RLS you can identify logged in user accessing the report and then pre-define what level of data that user can access.
Community Championvanessafvg Yes it is true that stored credential will be used by the report to connect to data source except analysis services regardless of who is accessing the report but you have control over who the report / dashboard is shared with. Also you have option of implemeting row-level security in your data model and that will allow you to control over what level and amount of data is seen by which user of the report. Find out more about RLS here and using UPN function of DAX within RLS you can identify logged in user accessing the report and then pre-define what level of data that user can access.