Forum Discussion

CJMolin's avatar
CJMolin
Icon for Helper II rankHelper II
9 years ago
Solved

Self entered data table cleared after refresh from Service-tool

Hello,   First of all Im not sure if this topic should lay under Desktop or Service since it concerns them both, sorry if I put it wrong.   Background: I've created a pretty big data model in Po...
Need Help
  • CJMolin's avatar
    CJMolin
    9 years ago

    Thank you for all your help Qiuyu.

     

    I was able to fix this issue with the help of one of our IT guys at work. He put up a new database for me so I can use it for lookups (so i had a source to point at at refresh).

     

     

cs_skit's avatar
cs_skit
Icon for Resolver IV rankResolver IV
9 years ago

In PBI Desktop if you go to Query Editor and remove that checkbox:

for the table in question only (right click it) before publishing

 

does that fix your issue?

CJMolin's avatar
CJMolin
Icon for Helper II rankHelper II
9 years ago

Hello,

 

Actually i found that option and tried it without any success. It still cleared my table! Thank you for quick reply cs_skit

  • cs_skit's avatar
    cs_skit
    Icon for Resolver IV rankResolver IV
    9 years ago

    Yeah sorry for those static tables I usually icreate the table in Excel quickly import and then stop the refresh I actually never published Enter Data stuff so far let me try that fast :)

    • CJMolin's avatar
      CJMolin
      Icon for Helper II rankHelper II
      9 years ago

      So you mean I should use an Excel file as a datasource containing the information I just put in using "Enter data"? cs_skit

       

      • cs_skit's avatar
        cs_skit
        Icon for Resolver IV rankResolver IV
        9 years ago

        Yeah you can do it its quick to create and import and if its just a static table disable refresha nd its fine

        You could also type the table manually in M but your probably more comfortable with Excel.

         

        In PowerQuery/Query Editor when importing from Excel use "First Row as Header" function after you imported.

         

        Strangely I just tried with "Enter Data" and I did not get the problem you are having data stays on refresh.