Forum Discussion

lishapruthi's avatar
lishapruthi
Helper I
3 years ago

Refresh time not reduce even after applying incremental refresh

Hello Everyone,   I have issue regarding incremnetal refresh. I have a dataset which is taking more than 2 hrs to refresh the dataset to reduce the time I have applied incremental refresh on the da...
Need Help
Tips and Tricks
Anonymous's avatar
Anonymous
Not applicable
3 years ago

Hi lishapruthi ,

For Incremental Refresh dataset, After publishing to the Power BI service, you can't download the dataset back as a .pbix to Power BI Desktop. Because datasets in the service can grow so large, it's impractical to download and open them on a typical desktop computer.

 

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

lishapruthi's avatar
lishapruthi
Helper I
3 years ago

Hi Anonymous ,

 

Right, I got this point. But still even after configuring the incremental refresh successfully, dataset is taking more than 2 hrs to refresh. Please help me to understand how I can solve this issue.

 

Thanks

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi lishapruthi ,

    Is it possible to describe your configuration process and provide screenshots?  because I can't tell exactly what went wrong, normally, if there is no problem with the configuration, this problem will not occur. For your sensitive information, please desensitize.

     

    Best regards,
    Community Support Team_Binbin Yu

    • lishapruthi's avatar
      lishapruthi
      Helper I
      3 years ago

      Hi Anonymous ,

       

      Below are the steps followed for configuring the incremental refresh:

      • Created parameters for StartDate and EndDate. 

       

       

      • Select the date column and apply date/time filters and setup the parameters dynamically. 

      • Configure incremental refresh in desktop view and then publish.

       

       

      Thanks