Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Incremental refresh questions

Hello everyone, I checked the documentation and watch tutorials but there are some issues that I want to be sure Here my questions: 1. We have to create parameters named as RangeStart and RangeE...
Need Help
Show and Tell
Tips and Tricks
v-lionel-msft's avatar
v-lionel-msft
Community Support
6 years ago

Hi Anonymous ,

 

1. "...but what are they for? ..."

In Power BI Desktop

 These parameters can be used to filter the data imported into Power BI Desktop.

(The column is filtered must has the same data type as parameter.)

In Power BI Service

Filter the dataset and dynamically partition the data into ranges once published to the Power BI service.

 

2. "...What should I write on RangeStart and RangeEnd?"

The values is decided by your business needs.

The parameter values are substituted by the service to filter for each partition.

There's no need to set them in dataset settings in the service.

Once published, the parameter values are overridden automatically by the Power BI service.

 

3. "Should I add incremental refresh to all tables which has suitable datetime column, are there any best practices?"

For your data model, you only need to add Incremental refresh to a table, because your data model is a whole.

 

4. "For direct query is it possible to create incremental refresh, or only for import tables? "


The best way is to do it:

Steps to set up Incremental refresh:

1. create parameters.

2. filter the date column

3. right click the table and set incremental refresh

4. publish the report

...

 

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

 

Anonymous's avatar
Anonymous
Not applicable
6 years ago

v-lionel-msft

Thanks for the answer,

(3). "Should I add incremental refresh to all tables which has suitable datetime column, are there any best practices?"

For your data model, you only need to add Incremental refresh to a table, because your data model is a whole.

 

Just to clarify, When I add incremantal refresh to one single table and does it effect whole model?

Thanks

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

    Hi Anonymous ,

     

    Yes, because there must be a relationship between the tables in your data model, even if there is no relationship between the tables, if you can refer to tables that is not related in a measure or calculated column, the tables can actually affect each other.

     

    Best regards,
    Lionel Chen

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.