cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Helper II
Helper II

Applying Submitted Paramter to Report

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.

2 REPLIES 2
Highlighted
Microsoft
Microsoft

Re: Applying Submitted Paramter to Report

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

Community Support Team _ Dale
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Highlighted
Regular Visitor

Re: Applying Submitted Paramter to Report

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

 

Helpful resources

Announcements
Community Blog

Community Blog

Visit our Community Blog for articles, guides, and information created by fellow community members.

Using the Community

Using the Community

Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.

Galleries

Galleries

Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors