Forum Discussion
Pass User ID parameter from embedded URL to stored procedure
To make my question clear, I am talking about user ID in embedded URL the way like this
Then I want the user ID to work on a parameter of my stored procedure in azure database.
Super UserGood. But my answer is still the same. You can't get the logged user with embed url. That's why power bi embed is created, for cases you have to manipulate things. The embed url is just to keep it the way it is.
You send how to filter an embed url. I say that if you are with publish to web you can't do it but if you are embeding with the login you can filter. However filtering by url is not the same of getting data from it.
I'm sorry I don't think you can get that data unless you have Power Bi Embed capacity.
Regards,
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
I'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.