Embedding Report with Power BI Report Server and external parameters

[hes-eng]

Hi,

I am embedding a report (saved on our Power BI Report Server) with an ASP .NET application.

Here is the piece of code that embeds the report on page:
 
page .aspx

<iframe id="frame1" scrolling="auto" runat="server" width="1000px;" height="600px"></iframe>

.cs code

protected void Page_Load(object sender, EventArgs e)
{
this.frame1.src="http://myserver/ReportsPBI/powerbi/Reports/test_param?rs:embed=true"; 
}

I am facing a problem about report parameters:

what I need is the possibility to extract, in the same report, different portions of data based on a external parameter passed in the URL.

To be more accurate, I need to show to different users just the portions of data that they can see (the source database has an application authentication).

How can I implement this feature in the .pbix project? And how can I pass the parameter through the URL?

Is it possible with Report Server on-premises or this feature is not supported?

Thanks in advance

[DavisBI · Accepted solution]

Hi, @hes-eng ,

We can use URL parameters as a filter in Power BI Report that hosted on PBI Report Server, just like the figure below.

For detail, you can refer to this document.

Mark this post as sulution if this helps.

[hes-eng]

Hi again @DavisBI , 

thanks for the help, it all works correctly.

I have another question: is there any method to hide to the user, data that hasn't have to see?

Because when I call the URL with the filter parameter, the user can then delete it and see all the data without limits (even the ones he shouldn't see).

Thanks again

[FarhanAhmed]

Then you might need to look into the Row Level Security for this purpose

https://www.sqlshack.com/introduction-to-row-level-security-in-power-bi/

https://radacad.com/row-level-security-configuration-in-power-bi-desktop