Forum Discussion
Power BI: PostgreSQL Error 42703 (“column does not exist”) when switching to identical table
Hi there
Thank you all very much for the valuable feedback: vojtechsima, Natarajan_M v-hjannapu
I tried everything. In the end, it turned out that I had to click “Refresh Preview” in Power Query for it to work. I had only clicked “Refresh” when the message “This preview may be up to xx days old” appeared. However, that message didn’t appear for the problematic table, since the error message popped up right away.
So the problem is solved.
Thank you very much for your help!
Hey, sande_ch ,
I would first do couple of things:
1) If you can, download Tabular Editor 2, it's free, and inspect your original data model for anything named as that phantom column; if you did resaved this from another report, it could be hidden somewhere
2) Clear cache from the settings
3) I would recommend going to the new report, where your simple M code works, and I would check the native Query, if you don't wanna write SQL yourself, and copy it and apply it do the new query, so you won't use the navigation and folding, but you will use custom query (that's usually the best approach regardless).
To get Native Query, click the working last step of the database query and you should see not greyed out option: