Is it possible to use a parameter from a stored procedure in Power BI?

[meddojeddo]

In SSRS, we have reports where the user's login is passed as a parameter for the stored procedure which returns values to be selected in another parameter. Is it possible to have this functionality in Power BI desktop? To set it up so that based on the user's login only certain values are visible based on the user's security role?

[v-luwang-msft]

Hi @meddojeddo ,

Has your problem been solved, if so, please consider Accept a correct reply as the solution to help others find it. 

Best Regards

Lucien

[v-luwang-msft]

Hi @meddojeddo ，

I think what you need is dynamic rls,It could allow different user view diferent data according his account.

The following article tells more details about it ,and tells how to configure,wish it is helpful for you!

Dynamic Row Level Security with Power BI Made Simple

Dynamic Row Level Security (Dynamic RLS)

Best Regards

Lucien

[AlexisOlson]

This sounds like Row Level Security.

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-rls

https://docs.microsoft.com/en-us/power-bi/create-reports/desktop-rls