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/
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/
ImkeFthanks for the input
So am I right in thinking that irrespective of whether the odata source can accept a filter that PowerBI always drops the recordset? Therefore incremental builds can only be achieved as you mentioned by moving the data out to CSV first?
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/