Power BI report switch datasource

[River]

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,

[v-yuta-msft]

@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]

No.

[River · Accepted solution]

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

[River]

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

[Greg_Deckler]

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

[River]

column is there, that's the problem.