Forum Discussion
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_DecklerCommunity Champion
The error should point you to the column name. Not sure how to be more helpful than that.
- RiverHelper IV
column is there, that's the problem.
- RiverHelper IV
Or, how I can clean out data, get it refresh?
- v-yuta-msftCommunity 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.