Forum Discussion

S3's avatar
S3
Helper III
3 years ago

SQL, Mac, and Power BI

Hello everyone, 

Due to the huge Data set I have and the many manipulation steps I have to do, I have to move the first steps from Power BI and to an SQL Server. 

However, because I'm using Mac, the SSMS doesn't work. I then found a solution to use DBeaver. 

Is there a way to connect DBeaver to Power BI without having to pay for the solution?

Thank you

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi S3 ,

     

    As far as I know, DBeaver should be a third party tool which need us to pay. You can refer to below blog to learn more details about the data source Power BI supports.

    For reference:

    Power BI data sources

    Here I suggest you to try ODBC connection to get data from SQL Server in Power BI.

    For reference:

    Importing SQL Server Data into Power BI Through an ODBC Connection

     

    Best Regards,
    Rico Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • S3's avatar
      S3
      Helper III
      3 years ago

      Hello Anonymous ,

      Thank you for your reply. 

      All I want is to use an SQL Server with my Mac (for Data manipulation) and then connect it to Power BI to create Dashboards. 

      The biggest obstacle is that I have a Mac and I can't change it now. The SSMS isn't downloading on my Parallels Virtual Machine because I have an M1 Chip..

      • gauravsharma955's avatar
        gauravsharma955
        New Member
        2 years ago

        Did your issue get resolved? I am having the same problem. 

        Tried everything but didn't worked.