Forum Discussion

dobregon's avatar
dobregon
Impactful Individual
7 years ago

Direct Query Filters in the report

Hi,   I have done a direct query into my database as an example   SELECT Element, TypeElement, Date, Cost From ElementCost    This "table" has a lot of information for years so it is n...
Need Help
Thejeswar's avatar
Thejeswar
Super User
7 years ago

dobregon,

Yes you can import the data by restricting for a certain period of time.

 

Incase if that is not possible, spend 4h to import it for the first time, but then implement Incremental Data Refresh to restrict the amount of data being imported.

 

The Query whoch importing the data should be like how v-frfei-msft has specified

 

In case if this is not possible, try concatenating the two columns "something like says 2014 - TypeElementValue"

 

Now filtering this after enabling an Apply button, should send the query only once to the report

  • dobregon's avatar
    dobregon
    Impactful Individual
    7 years ago

    Thanks for the reply Thejeswar 

     

    The incremental data refresh is a option (as I know, maybe i'm wrong) only for the premium users and for now i'm only a Pro user so, i can't do that.

     

    And i Can't concatenate the slicer because I have thousand of type elements and various years/month/days so for that i'm asking for an only 1 apply buttom becasue i see that i can put buttoms but they can't do an action to apply the slicers.

     

    Other thing that I'm thinking now is to do a SP with 3 paramaters (startdate, enddate, typeelement) and then write the 3 parameters and apply but i can't find how can select the parameter in the powerbi.app web when I publish the report.

     

    I see that they can writhe parameters in function of a query but I have tried to do that and i can't select a query. Is there any option?