Applying Submitted Paramter to Report

[petersi]

I have a question related to the ability to specify a means where a paramter is to be supplied to a report. I am currnelty integrating Power BI via a web application. We have the necessity to restrict data based on a user identification. This has to be done at the beginning and would limit the report to only show data based on the user paramter.

So the question would be is

1) how would you provide a paramter to a Power BI report where the paramter would be used as a filtering paramter of the underlying data sets being used in the report.

[Ashwinikhole]

Hi team,

I am trying to create parameter which will act as user defined filter and which will pass to the SQL query as a parameter.

MEMBER	PaidAmt
740007651	50000
740007651	70000
740007653	55000
740007653	60000

I want to create Paidamt as a parameter and need to pass it to SQL query so that whenever a user select any value it will filter the sql query.

I have created what if parameter and trying to pass the SQL code but it giving error like Expression. Error: The name 'Paidamt1' wasn't recognized. I am using below code:

(having sum(clf.PAID_AMOUNT)>'"& (Paidamt1) &"'#(lf)#(lf)#(tab)"]).

Could you help me to find out how i can apply parametrized filter into SQL code.

Thanks,

Ashwini

[v-jiascu-msft]

Hi @petersi,

As far as I know, Power BI use RLS (Row Level Security) to restrict access to a report or a dataset. I would suggest you read this documentation. There are so many details, I won't quote them here. And this is also helpful.

If you have any question about the technical details of RLS, I would recommend you to post in the Developer forum.

Best Regards!

Dale