topic Make PowerBI dashboard show only data relative to user in Report Server https://community.fabric.microsoft.com/t5/Report-Server/Make-PowerBI-dashboard-show-only-data-relative-to-user/m-p/3382714#M30838 <P>We have a SQL Server Database with real business data and we would like to give insight to our (external) customers using Power BI.</P><P>In our Web application we are using Power BI embedded with custom authentication.&nbsp;<SPAN>n Power BI we have successfully used UserName() and UserPrincipalName() DAX functions to retrieve user data.</SPAN></P><P>&nbsp;</P><P>On our database, we have a somewhat complex authorization system. We have already functions that return only the right data for the user we pass as argument. We would prefer to use these if possible.</P><P>It is much preferred that we don't import all the data to Power BI. (Huge amount of data and security concerns)</P><P>&nbsp;</P><P>Has anyone done that? Could you suggest how it can be done?</P> Wed, 16 Aug 2023 12:12:58 GMT kavehmb2000 2023-08-16T12:12:58Z Make PowerBI dashboard show only data relative to user https://community.fabric.microsoft.com/t5/Report-Server/Make-PowerBI-dashboard-show-only-data-relative-to-user/m-p/3382714#M30838 <P>We have a SQL Server Database with real business data and we would like to give insight to our (external) customers using Power BI.</P><P>In our Web application we are using Power BI embedded with custom authentication.&nbsp;<SPAN>n Power BI we have successfully used UserName() and UserPrincipalName() DAX functions to retrieve user data.</SPAN></P><P>&nbsp;</P><P>On our database, we have a somewhat complex authorization system. We have already functions that return only the right data for the user we pass as argument. We would prefer to use these if possible.</P><P>It is much preferred that we don't import all the data to Power BI. (Huge amount of data and security concerns)</P><P>&nbsp;</P><P>Has anyone done that? Could you suggest how it can be done?</P> Wed, 16 Aug 2023 12:12:58 GMT https://community.fabric.microsoft.com/t5/Report-Server/Make-PowerBI-dashboard-show-only-data-relative-to-user/m-p/3382714#M30838 kavehmb2000 2023-08-16T12:12:58Z