OS user as parameter?

Question

Hi,Is there a way we can pass user name in query so each user can download data from a table based on this parameter while user should not be able to change the query. We have oracle database and data in a table for different users so wants to restrict. Any assistance will be appreciated. Thanks

anonymous · Answer

Not a direct answer to your question, but the typical solution to your problem is to use DirectQuery and RLS.&nbsp;https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-rls/&nbsp;

sikandar · Answer

Hi Scottsen,Thanks for the update but seems this link not related to desktop version. Waiting for more inputs. Thanks

v-huizhn-msft · Answer

Hi&nbsp;Sikandar,&gt;&gt;We have oracle database and data in a table for different users so wants to restrictThe different uses can get different data, they filter the table based on their name? If it is, you need to create a&nbsp;parameter containing all name combinations for&nbsp;differents. Or you also&nbsp;use parametor in Power Query, please review the following article which shows the detailed operations.POWER BI DESKTOP QUERY PARAMETERS, PART 1Best Regards,Angelia

sikandar · Answer

Hi,Thanks for the reply and these filter are for data filteration by I want user id as parameter for data security. So will develop a dashboard and will share with all users and once they will connect will get their own data based on their OS user passed to query. &nbsp;Is there a way to get current OS user as environtment variable or any other way so can use in query like&nbsp;select name, amount from sales where user_id = username()&nbsp;thanks

ajohn1 · Answer

Have you been able to get any luck on your request? I'm looking to do the same thing with my company.

Forum Discussion

OS user as parameter?

5 Replies

Related content

Decimal Parameters in User Defined functions (UDF)

Fabric & Azure Data User Group Program Requirements & Benefits

OS user

Fabric User Data Function parameter defaults?

Community User Group Experience