Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Incremental Refresh working stop

We have applied Incremetal refresh in one of the PBIX file and deployed on power bi services. when we deployed and checked it successfully works first 2 to 3 times on servcies. But now it suddndly got sttoped to work on power bi services. we have have refer below link and applied correclty and it works first 2 to 3 times. is any one having any idea about this.

 

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

 

Need Help

3 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Native query used in Incremental

      Is mysql database support incremental refresh feature or not within power BI 

      Please check we are using above query and also our other report normal refresh working propelry within services.

  • v-xicai's avatar
    v-xicai
    Community Support
    6 years ago

    Hi Anonymous ,

     

    It is not recommended that incremental refresh is used when the required query folding cannot take place. For more detailed information on query folding, please see the incremental refresh docs article.

    Given the various levels of query-folding support for each data source, it is recommended that verification is performed to ensure the filter logic is included in the source queries. To make this easier, the February update of Power BI Desktop will attempt to perform this verification for you. SQL based data sources such as SQL, Oracle and Teradata should be able to rely on this warning. Other data sources may be unable to verify without tracing queries. If Power BI Desktop is unable to confirm, the warning is displayed.

     

    Note: if the PBIX file was authored in a version of Power BI Desktop prior to the February release, the warning will be displayed regardless until a data refresh is performed.

     

    Here is a video you might find useful that discusses query folding for incremental refresh: https://www.youtube.com/watch?time_continue=108&v=RnrCKn5ykCc&feature=emb_logo

     

    Best Regards,

    Amy 

     

    Community Support Team _ Amy

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