Forum Discussion

Jove's avatar
Jove
Frequent Visitor
2 years ago
Solved

Refresh error, missing column in table .

I am no longer able to refresh in Desktop, but when I publish to the service this Model and report refresh just fine.   The column named MWH does exist, it's the "table ." that has me really confus...
Need Help
  • Jove's avatar
    Jove
    2 years ago

    After a week of stuggling I solved this myself. It was related to a table from another dataset. The table showed the column but after deleting the issue resolved itself. 

  • Jove's avatar
    Jove
    2 years ago

    The other dataset had deleted the table, so the relationship defined in my model was referring to a table that no longer eixsted when refreshing, but the table was still in the older model so I did not realize it was missing. Since the table was gone, it had no name to display. 

Jove's avatar
Jove
Frequent Visitor
2 years ago

After a week of stuggling I solved this myself. It was related to a table from another dataset. The table showed the column but after deleting the issue resolved itself. 

Jove's avatar
Jove
Frequent Visitor
2 years ago

The other dataset had deleted the table, so the relationship defined in my model was referring to a table that no longer eixsted when refreshing, but the table was still in the older model so I did not realize it was missing. Since the table was gone, it had no name to display.