topic Re: SQL, Mac, and Power BI in Developer

SQL, Mac, and Power BI

S3 — Thu, 29 Dec 2022 15:17:41 GMT

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

Re: SQL, Mac, and Power BI

Anonymous — Fri, 30 Dec 2022 07:55:30 GMT

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.

Re: SQL, Mac, and Power BI

S3 — Fri, 30 Dec 2022 09:37:40 GMT

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..

Re: SQL, Mac, and Power BI

gauravsharma955 — Sat, 16 Mar 2024 03:55:36 GMT

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

Tried everything but didn't worked.