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!

     

sande_ch's avatar
sande_ch
Helper I
4 months ago

Hi there

The M-Code in Power Query is:
let Quelle = PostgreSQL.Database("Server", "Database"), powerbi_taritemp_unfallliste_buv = Quelle{[Schema="powerbi",Item="taritemp_unfallliste_buv"]}[Data] in powerbi_taritemp_unfallliste_buv