Forum Discussion

Verknuepfer's avatar
Verknuepfer
New Member
5 years ago

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. ...
Need Help
collinq's avatar
collinq
Super User
5 years ago

Hi Verknuepfer ,

 

What is the error message that you are receiving when you try to refresh the table that fails?

 

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!

  • Verknuepfer's avatar
    Verknuepfer
    New Member
    5 years ago

    Hi collinq ,

    thanks for messaging. I don't receive any kind of error message, thats what make me struggle so hard. Everything seems to do as it shoud - but the reference tables are not refreshed.

    Regards

    Mark

    • spock1984's avatar
      spock1984
      Frequent Visitor
      5 years ago

      Hi Verknuepfer,

      Have you figured out how to solve this? I have exactly same issue... 

      • Verknuepfer's avatar
        Verknuepfer
        New Member
        5 years ago

        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