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.

 

When I am refreshing my data on my Desktop, everything is working fine. But if I make the refresh on the service, the 3-5-Table won't get any refresh. But my SD-Data does. I am working with only a small dataset on my Desktop and want to make a bigger load on the service, thats exactly where the problem occurs.

 

I permitted "enable load" and "include in report refresh" for both tables in the query editor. I even tried to add a step in my m-code as "Table.Buffer(PreviousTable)" - no reaction. Other tables which are also referenced on SD_Data have the same behaviour.

 

I load SD_Data via import-mode from SAP Business Warehouse.

Version is 2.85.985.0 64-bit (September 2020)

Our Service has Premium capacity

 

Anybody an idea what could be the cause?

 

Thanks a lot in advance!
BR
Mark

Need Help

5 Replies

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    I am facing similar issue. Did anyone get answer for above question ?