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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

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
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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

Top Solution Authors
Top Kudoed Authors