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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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

Top Solution Authors