Forum Discussion
Find Max Value After Odata Query & Insert
Thats basically correct if you Don't run premium. There's another alternative, but I doubt that it will cover your request: https://www.thebiccountant.com/2017/01/11/incremental-load-in-powerbi-using-dax-union/
So, are you using Premium then and have incremental refresh? Power BI queries generally refresh everything in a table as opposed to inserting it unless you have incremental refresh or are R or Pythonin a query step to call out to an external database.
If you do have a way around it, ImkeF is probably the fastest way to get an answer.
Exactly that Greg, I am trying to run incremental updates via Odata...Odata v4 supports filtered query, but I need to update based on the current recordset. My Power Query is not my strongest area of Power BI
Yeah, mine neither! That's why I always call in the calvary with ImkeF! See's a Power Query supra genius!
Hi,
please check this article: https://www.thebiccountant.com/2016/02/09/how-to-create-a-load-history-or-load-log-in-power-query-or-power-bi/
Meanwhile you can also use Python-script to export if you prefer that: https://www.thebiccountant.com/2018/12/29/export-data-from-power-bi-to-csv-using-python/
