Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
Solved! Go to 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.
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.
Hii,
here are the queries, Original source table + two reference table + appendi
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.
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,
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?
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
Hi @Anonymous,
but the historical data are already saved in the final query.
Do they have to go through the query process again?
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?
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
100 | |
81 | |
70 | |
62 |
User | Count |
---|---|
148 | |
116 | |
104 | |
90 | |
65 |