user inputs to filter data from server

[froxas]

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?

[v-eachen-msft]

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.

[froxas]

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

[GilbertQ]

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

[venal]

@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.

[froxas]

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

[GilbertQ]

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?

[froxas]

@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.