SQL, Mac, and Power BI

[S3]

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

[Anonymous]

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]

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]

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

Tried everything but didn't worked.