Forum Discussion

froxas's avatar
froxas
Helper II
6 years ago

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?

 

Need Help

7 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    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's avatar
      froxas
      Helper II
      6 years ago

      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.

       

  • venal's avatar
    venal
    Memorable Member
    6 years ago

    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's avatar
      froxas
      Helper II
      6 years ago

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

  • v-eachen-msft's avatar
    v-eachen-msft
    Community Support
    6 years ago

    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.