Forum Discussion
Pass User ID parameter from embedded URL to stored procedure
Super UserHi. I don't think this will be available. If you want to capture the user login and manage everything in an embed, then you must buy Power Bi Embed capacity from azure to control this. That way you develop what you want to see and take the data you need. You can do RLS and much more. Embed by URL is just for the whole report. If you are using a publish to web then it won't ever have an url filter.
Hope this help,
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.
- ibarrau
Good. 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?