Pass User ID parameter from embedded URL to stored procedure

Question

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 stored procedure and work as a filter. From I can see in below links, this function is still not available? Can some one confirm this? Is there a work around?

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/35664793-pass-a-parameter-s-to-the-sql-behind-the-power-bi

https://community.powerbi.com/t5/Report-Server/Power-BI-Embedded-and-Stored-Procedure-parameter-passing/m-p/374855

ibarrau · Answer

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.
&nbsp;

ibarrau · Answer

Hi. 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.
&nbsp;
Hope this help,

anonymous · Answer

To make my question clear, I am talking about user ID in embedded URL the way like this

https://stackoverflow.com/questions/37986615/how-to-pass-parameter-to-powerbi-embedded-via-embedded-url

Then I want the user ID to work on a parameter of my stored procedure in azure database.

ibarrau · Answer

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.
&nbsp;
I'm sorry I don't think you can get that data unless you have Power Bi Embed capacity.
Regards,

anonymous · Answer

Yes I do have power BI embedded. As what I said in my question, 'I have some reports embedded in my application.'&nbsp;&nbsp;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?

Forum Discussion

Pass User ID parameter from embedded URL to stored procedure

7 Replies

Related content

Stored Procedure to Manipulate Tables

Passing PowerBI Parameter To A Stored Procedure

Data compression Procedure

Passing Date Parameters to a Stored Procedure

PBI Embedded