How to fetch data from SQL Server based on logged in user email address in PorwerBI with single stored procedure taking email address as parameter

Asked May 12 '20 at 18:30

Active May 12 '20 at 19:00

Viewed 25 times

How to fetch data from SQL Server based on logged in user email address in PowerBI with single stored procedure accepting the email address for logged in user as a parameter?

Actually I want to use single data set and logged in user should see only his organization data with single data set and data should not be visible to other users

edited May 12 '20 at 19:00

marc_s

732,580
175
1,330
1,459

asked May 12 '20 at 18:30

Ali Nafees Dhillon

How frequently does your data change? Can you use an import model and row level security? Does your data fit in memory? – GregGalloway May 13 '20 at 01:49
actually I want to use live connection for some reasons – Ali Nafees Dhillon May 13 '20 at 11:07
so for live connection if you have some solution then let me know – Ali Nafees Dhillon May 13 '20 at 11:07

How to fetch data from SQL Server based on logged in user email address in PorwerBI with single stored procedure taking email address as parameter

0 Answers0