Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

ERROR REFRESH The '<oii>Column</oii>' column does not exist in the rowset. TablE

Hey,

I have an issue when trying to refresh my PBI online. The following message appears :

Nothing was moved in my files and the column6 still exists.

I already found solutions on the forum and applied them but nothing changes (clear the cache on desktop, refresh and republish...).

 

Any ideas ?

Thanks for your help 🙂

 

Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hello collinq , thanks for your answer but it doesn't help me.

    In fact, one of my file had an issue that I managed to solve in Query, related to the positionning of a column that I permuted few months ago when I built the PBI (idk why PBI bother me now, a long time after making this change?).

    However, there are no problems anymore in my data, and the PBI is working on my Desktop, data is accurate and I can correctly refresh my file.

    I went through all steps and nothing is wrong but still, I cannot refresh my PBI.

     

    Thanks for your help.

     

  • Anonymous's avatar
    Anonymous
    2 years ago

    Hello, nobody found a solution, I did it by myself 🙂

7 Replies

  • collinq's avatar
    collinq
    Super User
    2 years ago

    Hi Anonymous ,

     

    If the column is still there, I would open this in Desktop and go through each applied step.  It might be that in one of your steps you may have re-ordered or renamed or did something that is looking for that field name but it is not where it is as expected.  It might not be that this specific column is the "error" but that the step is looking for it or a version of it and not finding it.

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hello collinq , thanks for your answer but it doesn't help me.

      In fact, one of my file had an issue that I managed to solve in Query, related to the positionning of a column that I permuted few months ago when I built the PBI (idk why PBI bother me now, a long time after making this change?).

      However, there are no problems anymore in my data, and the PBI is working on my Desktop, data is accurate and I can correctly refresh my file.

      I went through all steps and nothing is wrong but still, I cannot refresh my PBI.

       

      Thanks for your help.

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Thanks for the reply from collinq.

         

        Hi Anonymous , 

         

        Glad to hear your issue has been resolved, can you mark your reply as solution to close this topic. Your contribution is highly appreciated.

         

        Best Regards,
        Zhu
        Community Support Team

         

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