Forum Discussion

Macwin's avatar
Macwin
Helper I
6 years ago
Solved

Updating Datasource without loading from start

Im looking for a solution to update my large database without reloading everything. just import new records. My Data source is coming from postgres sql view (getting data every 24 hours in a 1 hour ...
Need Help
  • v-xicai's avatar
    v-xicai
    6 years ago

    Hi Macwin ,

     

    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. 

     

     

    Reference:

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

     

    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.

Macwin's avatar
Macwin
Helper I
6 years ago

Im using Premium service and I already found the page about incremental refresh (But I dont know how it should work) and I cant use query mode because of the big dataset im using. (lifetime aggregations)

Also I dont even need power query.

 

 

I cant get further till step 

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

 

its always disabled. 

How I should I set up the incremental refresh on my my example above ?

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

    Hi Macwin ,

     

    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. 

     

     

    Reference:

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

     

    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.