Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

what is a good SQL server that works well with power BI

im looking for a good SQL server that works well with power BI. alot of my reports come from power BI. looking for a good SQL server to pull data from that works well with power bi. 

2 ACCEPTED SOLUTIONS
djurecicK2
Super User
Super User

Hi @Anonymous 

 There are a lot of supported data sources- here is the list:

https://learn.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

 

Microsoft SQL Server and Azure SQL Database are both good choices.

 

View solution in original post

djurecicK2
Super User
Super User

That's kind of outside the scope of these forums- here is an article to get you started:

https://adamtheautomator.com/microsoft-sql-server-standard-edition/

 

View solution in original post

5 REPLIES 5
djurecicK2
Super User
Super User

That's kind of outside the scope of these forums- here is an article to get you started:

https://adamtheautomator.com/microsoft-sql-server-standard-edition/

 

djurecicK2
Super User
Super User

Hi @Anonymous 

 There are a lot of supported data sources- here is the list:

https://learn.microsoft.com/en-us/power-bi/connect-data/power-bi-data-sources

 

Microsoft SQL Server and Azure SQL Database are both good choices.

 

Anonymous
Not applicable

is mysql = microsoft SQL server?

Hi @Anonymous ,

 

No, MySQL is an open source database (with some companies crating and selling their own spin on it).  As @djurecicK2 stated, Azure and Microsoft SQL are good choices and I would say the "best" SQL choices to use.  BUT, technically, you can connect to other SQL options and you can use "any" of them but they have differetn capabilities and different security configurations.

 

I would suggest you research the SQL differences and understand why you might pick one over another for your needs.




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!
Private message me for consulting or training needs.




Anonymous
Not applicable

thank you! i think ima go with microsoft SQL server. do i need anything in particular to download it and get it running? or once i download it i can start importing data into it?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors