Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Importing data from DBeaver

Is it possible to import data from DBeaver? We use DBeaver to manage our dataset but I'd like to prevent having to manually export data into a file and then go into Power BI to import that file. 1) this is tedious, and 2) the report generated is a 'snap shot' and the export/import will need to be repeated periodically to  make sure the data is up to to date.

Need Help

3 Replies

  • v-easonf-msft's avatar
    v-easonf-msft
    Community Support
    6 years ago

    Hi , Anonymous 

    Can you tell me what data source is connected to Dbeave?

    Maybe you  can try to connect to the data source directly in powerbi desktop.

    BTW, Is that possible connect that by ODBC?

     

    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      It's a postgreSQL server through an SSH tunnel.

      Our remote server is hosted on jupyter and we have to go through the SSH tunnel to retrieve the data.

      Can I connect by ODBC through SHH tunneling?

      • v-easonf-msft's avatar
        v-easonf-msft
        Community Support
        6 years ago

        Hi , Anonymous 

        I'm sorry, that I don't know much about it.

        Best Regards,
        Community Support Team _ Eason
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.