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.
Commenting to get more information on this as I will be playing with this concept in the near future.
When you amnnually refresh the reference and append tables does it pull in the new data?
In desktop, we have the data filtered according to the parameters, but after publication, the refresh in append, reference and merge query it just takes incremental refresh the data of a month of the source query, not all the history,