Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
froxas
Helper II
Helper II

user inputs to filter data from server

Hi,

 

I am building a solution and show data in table visual where views are very dynamic and depends a lot on user's selection.

the problem is that in order to estimate what data to show to user i need to download all data from server, then make estimations and then show in table visual.

 

Is there some possibility or other solution where I could grab data from server only according users selection? Or maybe I could use some other technology for that?

 

7 REPLIES 7
v-eachen-msft
Community Support
Community Support

Hi @froxas ,

 

Do you mean to configure the data source according to the user's selection? I don't think it is possible and the normal way is to use RLS or filter to limit what users saw in the report.

 

Community Support Team _ Eads
If this post helps, then please consider Accept it as the solution to help the other members find it.

@v-eachen-msft  and are there other tools to atchieve it?

Hi there

yes it is currently not possible to be able to do this currently.

You could look for or create an idea on https://ideas.powerbi.com




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

venal
Memorable Member
Memorable Member

@froxas 

Please try to check with the below url to pass the data in parameters to filter the data.

 

https://docs.microsoft.com/en-us/power-query/power-query-query-parameters

 

https://powerbi.microsoft.com/en-us/blog/deep-dive-into-query-parameters-and-power-bi-templates/

 

https://www.youtube.com/watch?v=iiNDq2VrZPY

 

If this post helps, then please consider Accept it as the solution to help the other members find it more
If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

 

BR

venal.

power query is not solution, in my option user needs to choose parameters in power bi online service

GilbertQ
Super User
Super User

Hi there

Are you talking about power BI report server or the Power BI Service?

And could you give an example of what you mean by the user selecting data?

I would include all the required information for users to view and interact with the reports?




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

@GilbertQ 

 

I am talking about  Power BI Service.

User needs to add inputs like: start date, end date, financer, product etc. But mainly it depends on a start and end date, because according user selected dates it is calculating contract versions, contract status, transactions to show and so one. and now i need to pull all the data, and then according the user selected slicers i need to make recalculate what to show.

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors