Forum Discussion
Reference tables data not refreshing on Service
Hallo everyone, I am dealing with a strange behaviour on PBI-Service. I have my fact-data "SD_Data" a reference table "3-5_Customer_Fact_ProdOpt" which is a simple group by on the SD_Data table. ...
Hi Verknuepfer,
Have you figured out how to solve this? I have exactly same issue...
Hi spock1984
we switched our data source from SAP BW to HANA and don't have this problem anymore.
But I spent a lot of time with the Microsoft support to figure this out.. probably it has to deal something with the query folding: Query folding | Microsoft Docs
We had some preparation steps after loading the data from SAP BW (Change data type, text functions, etc.). This might caused the problem.. now in HANA we prepared views which don't need to be changed in Power BI. Out of PBI we make a select * and everything works proper.
I hope this will help you
Best regards
Mark