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.

JarroVGIT's avatar
JarroVGIT
Resident Rockstar
6 years ago

Unfortunately, Incremental Refreshes (that is what you are after) is only available in PowerBI Premium:

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

 

What you could do is implement a DirectQuery on some sort of Datawarehouse solution, in which you perform the necessery transformations that you are currently doing in PowerQuery. That way, your report is always up to date but you will move your problem back in your data pipeline. This would entail a re-architecturing effort of your data pipeline.

 

 

Kind regards

Djerro123

-------------------------------

If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.

Keep those thumbs up coming! 🙂