Forum Discussion

sande_ch's avatar
sande_ch
Helper I
4 months ago
Solved

Power BI: PostgreSQL Error 42703 (“column does not exist”) when switching to identical table

Hi everyone, I’m facing an issue in Power BI that I can’t explain. I have built a fairly complex report with: a complex data model multiple tables imported from PostgreSQL many measures Now I...
Need Help
  • sande_ch's avatar
    sande_ch
    4 months ago

    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!

     

v-hjannapu's avatar
v-hjannapu
Community Support
4 months ago

Hi sande_ch,

I would also take a moment to thank vojtechsima , for actively participating in the community forum and for the solutions you’ve been sharing in the community forum. Your contributions make a real difference.
 

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Regards,
Community Support Team.