Forum Discussion
Problem refresh incremental Connexion SAP Hana for Reference, Append and Merge Query
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,
Hey Anonymous
I believe you may have to have the incremental refresh enabled for the reference as well. Check out this link: https://radacad.com/all-you-need-to-know-about-the-incremental-refresh-in-power-bi-load-changes-only
My other theory based on the threads from when the preview of incremental refresh was released is that since the historical data is stored differently in the original query after the incremental refresh the referenced tabled does not "see" the historical data when referencing the original query. Enabling Incremental refresh on the reference query (and others) should solve this, but I don't have the ability to test this yet and there isn't clear documentation on this problem. The alternative is to duplicate the original query instead of referencing it, make the necessary changes, and set up incrememntal refresh for the duplicate.
- 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 complicatedIt is here I put the source table, in the query reference ??