Forum Discussion
Pass User ID parameter from embedded URL to stored procedure
I have some reports embedded in my application. What I want to achieve is, when user login to our application, we catch their user ID information in embedded URL, and pass this to a parameter in a st...
Yes I do have power BI embedded. As what I said in my question, 'I have some reports embedded in my application.'
My questions is, all the cases I saw online, they use this to filter on a table column, not to pass this value to a parameter in a stored proc. Does it work for a stored procedure?
ibarrau
Super User
Super UserI'll ask to my mates here to help. I can't see the idea of the store procedure. You can use a store procedure as datasource in a power bi report, but executing it from code won't make any difference for the power bi. Power bi manage its own flow of data. That is why you filter it by url or manage roles wihin the embed.
Yes I use stored proc as data source. But it is a stored proc with a user ID parameter. Thanks.