topic Re: Dynamically Update Query Based on User ID - Power BI Embedded in Developer

Dynamically Update Query Based on User ID - Power BI Embedded

mcostner — Fri, 06 Apr 2018 13:18:01 GMT

Hi Everyone,

I recently embedd a Power BI report into a web app. Data are gathered from a SQL Server database.

When a user logs into the web app, I'd like for the queries to update based on that user's ID. So, something like the statement below where the "userid" value dynamically changes.

select * from table where userid = 1234

My initial thought was to use row level security, but since we have hundreds of users, setting up the individual role for each user seems like an inefficient process. I don't want to add the userid as a filter since a user could clear the filter and then see other user's information.

Passing the userid as part of a URL parameter would be ideal but that doesn't seem like it is possible according the link below.

https://docs.microsoft.com/en-us/power-bi/service-url-filters

Has anyone come across this requirement before? Any thoughts or suggested solutions would be greatly appreciated.

Thanks!

Michael

Re: Dynamically Update Query Based on User ID - Power BI Embedded

v-micsh-msft — Wed, 11 Apr 2018 09:28:55 GMT

Have you checked the Power BI Embeded Query parameter API?

If the UserId could be defined as a Query Parameter, then you could take use of the API to update it.

Check the API refernece:

Set parameters

Regards,

Michael

Re: Dynamically Update Query Based on User ID - Power BI Embedded

Alexander24 — Thu, 12 Apr 2018 22:14:51 GMT

Hi Michael,

I recently asked a question about Query Parameters API and not had a reply yet

When Setting Parameters I am encountering an issue, it may also help Michael above with his query parameters if he has a problem.

http://community.powerbi.com/t5/Developer/Query-Parameters-API/m-p/391898#M11635

Thanks
Alexander

Re: Dynamically Update Query Based on User ID - Power BI Embedded

RyanStewart — Tue, 19 Oct 2021 18:42:13 GMT

Was there ever a good resolution to this issue? I am curious about doing a similar thing. The links provided about the API were not clear to me.

Any more information?