Forum Discussion

Analitika's avatar
Analitika
Post Prodigy
5 years ago

Postgresql connection in Power BI

Hello,

 

I would like to ask how to define a source for postgresql in advanced editor, instead Sybase.Database I am started to use PostgrSQL.Database, no syntax errors but still getting that this function is not correct.

Need Help

2 Replies

  • parry2k's avatar
    parry2k
    Super User
    5 years ago

    Analitika add a new get data connection using PostgreSQL, connect to a table and from advanced editor , take the connection and paste in your original (Sybase) query

     

    ✨ Follow us on LinkedIn

     

    Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

     

    ⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡

  • Analitika's avatar
    Analitika
    Post Prodigy
    5 years ago

    Hello,

     

    I have already the connection to PostgreSQL but I am not sure about the sybase query content in that report. I have changed Sybase.databases to PostgreSQL.databases via advanced editor but it not helped.