Forum Discussion

answeriver's avatar
answeriver
Helper IV
6 years ago
Solved

Incremental refresh

Hi all. Can somebody explain to me about this feature. I have desktop report with huge data. Every day my data is updating of new data. Refreshing full report it so much time need. Question is, do i...
Need Help
  • v-lionel-msft's avatar
    v-lionel-msft
    6 years ago

    Hi answeriver ,

     

    1. Incremental refresh is configured in Power BI Desktop and performed in Power BI Service.

    2. The values of the two parameters (RangeStart & RangeEnd) can be set to any value, as they will be overwritten by subsequent settings.

    "Then create two parameters of DateTime data type, with names of RangeStart and RangeEnd, set a default value for each too. The default value can be anything, but the name and the data type should be as mentioned here."
    "After doing this action, your data in the table will be filtered based on the default values you have set for the RangeStart and RangeEnd parameters. However, don’t worry about that. these two parameters will be overwritten with the configuration you make in the Incremental Refresh setting of the Power BI Desktop."
     
    For more, you can refer to this article, which is very detailed:
     

    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.

TomMartens's avatar
TomMartens
Super User
6 years ago

Hey answeriver ,

 

the simple answer is no, you need Power BI Desktop to setup and Power BI Service to perform the incremental refresh.

 

Here are two articles that explain

https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh

how to use incremental refresh and the announcement that incremental refresh is now available for Power BI Pro

https://powerbi.microsoft.com/en-us/blog/tag/incremental-refresh/

 

Hopefully, this helps to tackle your challenges.

 

Regards,

Tom

jmg80525's avatar
jmg80525
Helper II
6 years ago

TomMartens  Thanks for you clarification.  I've spent a better part of the day trying to get this figured out.  Have a time series dataset w/ 90 million plus rows and growing at 64k plus a day with a tremendous amount of cardinality.  I thought that by implementing incremental refresh I would prevent the need to reload the dataset inside the pbix every time I made a change in PQ and applied the transfromation.  From your comment to original poster above I now assume that is incorrect. Incremental refresh is about data refresh at the service level.