Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Trying to implement report templating, I have row level security established on my postgres datasource and a separate web ui that enables admin to determine what is in that RLS. These users need to interact with a report and only see data that belongs to them. My backend can handle this fine but I cannot figure out how to implement the different user access as the database and server are the same for everyone, their credentials are what need to change.
Separately, I am embedding the reports and have noticed I could specify a dataset Id and report ID, and so tested generating two reports but changing the db credentials between reports, when I publish them and look at them in the webservice, the report ids and dataset ids are unique, but the data is the same and changing the connection settings on the specific dataset changes both.
Questions:
Thanks!