Forum Discussion

River's avatar
River
Helper IV
6 years ago
Solved

Power BI report switch datasource

Hi Friends,

 

I tried to change data source from dev to my prod in report, when I apply changes, it starts refreshing data, later stopped saying the one of column is not in one of the table. Dev and Prod is exact same in term of schema. I don't know why it gave this error.

 

Anything I can try to figure out?

 

Many thanks,

 

  • Figured out issue, it's problem lies in View, which is missing column. Thanks everyone for help.

6 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion

    The error should point you to the column name. Not sure how to be more helpful than that.

    • River's avatar
      River
      Helper IV

      column is there, that's the problem.

  • Or, how I can clean out data, get it refresh?

  • v-yuta-msft's avatar
    v-yuta-msft
    Community Support

    River ,

     

    If there any unprintable character in the column name?

     

    Community Support Team _ Jimmy Tao

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

      • River's avatar
        River
        Helper IV

        Figured out issue, it's problem lies in View, which is missing column. Thanks everyone for help.