Forum Discussion
Problem refresh incremental Connexion SAP Hana for Reference, Append and Merge Query
Hello, I have an incremental refresh problem in powerBI for SAP Hana connection, the incremental refresh works for the source table, but for the reference table and append table, the incremental ...
Hi Anonymous,
i think you have to filter the original query to reduce the data from hana
and the appred query to control the storage of the historical data.
I can have more detail, how to do the incremental in the reference table,
I did a test with the Dax union (for append) and it works, but for the references it's a little complicated
It is here I put the source table, in the query reference ??
This is the part I am not sure on and why I may suggest creating a duplicate query for now until there is more support documentation for incrememntal refresh on reference queries.
I'll tag some more advanced users to see if they have any thoughts.