cancel
Showing results for 
Search instead for 
Did you mean: 
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
Resident Rockstar
Resident Rockstar

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
Resident Rockstar
Resident Rockstar

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
Resident Rockstar
Resident Rockstar

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
Resident Rockstar
Resident Rockstar

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
PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Top Solution Authors
Top Kudoed Authors