Problem refresh incremental Connexion SAP Hana for Reference, Append and Merge Query

[Anonymous]

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 refresh doesn't work, how can I make the incremental refresh for the reference table and appendix table work on powerBI?

Thanks,

[v-lionel-msft]

Hi @Anonymous ,

Could you show your queries of your reference table and append table?

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Hii,

here are the queries, Original source table + two reference table + appendi

[mwegener]

Hi @Anonymous ,

i think it works this way.

You have to insert the filter parameters in the "original" query and in the "final" query.

In the "original" query, so that the data can be filtered in the source by query folding.

In the "final" query, so that the parameterization is activated and the result of this query is saved.

I assume that the parameter of the "final" query will be forwarded to the "original" subquery.

[Anonymous]

Hi @mwegener 

How can I access the filter parameters in the reference table and the append table?

I add parameter filters in all queries ?

Thanks,

[mwegener]

Hi @Anonymous,

I think you can only set the parameters in the final query.
The other queries should be executed as subqueries and have the same parameter values as the final query.

Can you confirm my guess?

[Anonymous]

My problem is the sub-requests, just take the refreshes of the original request (source Hana), so I will have only the incremental data in the sub-requests and I will not have history in apprend and reference query

[mwegener]

Hi @Anonymous,

but the historical data are already saved in the final query.

Do they have to go through the query process again?

[Anonymous]

hi @mwegener 

I put the filter in all the queries ??

[mwegener · Accepted solution]

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.

[Anonymous]

Hello @mwegener 

Thanks, it's ok 😊

[Tad17]

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?

[Anonymous]

Hello Tad17

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,

[Tad17]

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.

[Anonymous]

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 ??

[Tad17]

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.

@amitchandak 

@mwegener