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. 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Jove ,

    Congratulations on solving the problem through your own perseverance, and thank you for sharing your thoughts on how to solve the problem, which can likewise help other users on the forum.

     

     

    Best Regards

    Yilong Zhou

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.