cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Re: Passing parameters to a Power BI report in Power BI Report Server

How we can pass dax function username() to sql query query to fetch data only for logged in user?

 
 How we can pass dax function username or userprinciple name to sql query to retrive data for power BI report. We don't want to load all data then apply filter. only load data only for logged in user name. 

Using procedure 

 

RetriveDataForLoggedInUser(@StartDate,@EndDate, @LoggedInUserName)

 Row level securty work when data is loaded completely in power BI.

 

Please suggest?

Highlighted
Anonymous
Not applicable

Re: Passing parameters to a Power BI report in Power BI Report Server

Anyone have an update on this?  We need to be able to filter data in PBI ReportServer reports.  If this is not going to be implemented, it could be the last nail in the coffin for using Power BI in my organization.  We need to be able to filter data based on user credentials through parameters.

Highlighted
Frequent Visitor

Re: Passing parameters to a Power BI report in Power BI Report Server

I did not get response on this, may be there is no such feature yet. which is most required. Analysing in entire data is very dificult.

Highlighted
Frequent Visitor

Re: Passing parameters to a Power BI report in Power BI Report Server

Any update on the above request?

Highlighted
Frequent Visitor

Re: Passing parameters to a Power BI report in Power BI Report Server

Auy update on the below request

Highlighted
Regular Visitor

Re: Passing parameters to a Power BI report in Power BI Report Server

http://PowerBIServer/Reports/powerbi/ReportPathAndName?filter=QueryName/Column eq 'USERNAME'

 

PowerBIServer: BI Server URL

ReportPathAndName: Report path and name eg: Type1/ProjectProgress

QueryName: Query Name

Column: Column using in Query eg: username

USERNAME: User Name or any value you want filter data

 

 

 

Highlighted
Regular Visitor

Re: Passing parameters to a Power BI report in Power BI Report Server

http://PowerBIServer/Reports/powerbi/ReportPathAndName?filter=QueryName/Column eq 'USERNAME'

 

PowerBIServer: BI Server URL

ReportPathAndName: Report path and name eg: Type1/ProjectProgress

QueryName: Query Name

Column: Column using in Query eg: username

USERNAME: User Name or any value you want filter data

 

 

 

Highlighted
Advocate II
Advocate II

Re: Passing parameters to a Power BI report in Power BI Report Server

Not sure I agree with the accepted solution on this one.  Maybe it shouldn't have the green check mark on it if the answer is "This functionality is not yet supported"...it should be left "unsolved"

Highlighted
Helper V
Helper V

Re: Passing parameters to a Power BI report in Power BI Report Server

Highlighted
Helper V
Helper V

Re: Passing parameters to a Power BI report in Power BI Report Server

This is NOT a power bi report.  It's an RDL report which has had that functionality always.   This is a badly needed feature in Power BI Report Server .  MSFT needs to implement it.     PLEASE ask for it.

Helpful resources

Announcements
May 2020 Community Highlights

May 2020 Community Highlights

It’s time for another PBI Community recap!

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!

Top Kudoed Authors