cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Any benefits of using MSSQL with PowerBI instead of another DBMS?

We currently need to choose the database management system(DBMS) that we will use to store our data that will be displayed on Power BI Online.

 

We are wondering if there are any additionnal benefits to choose Microsoft SQL Server over another DBMS like PostgreSQL for example.  Since SQL Server is also a Microsoft product (like Power BI) we are curious to know if there are any additionnal benefits of using it with Power BI.

 

I know there are differences between SQL Server and other DBMSs, but I am wondering if there are benefits that are very specific of using it as a data source for Power BI (ex: is the refresh rate better, are there more extracts, is it better for direct query than using PostgreSQL, ...)

Note: The DBMS that we will choose will be hosted on Azure.
Thanks!

3 REPLIES 3
GilbertQ
Super User
Super User

Hi there

I would recommend looking into DirectQuery for Power BI, it can have a lot of demand on the underlying DBMS system that you use.

With that being said I would recommend Azure SQL because it has direct integration with Azure, where you do not need a gateway and if you have Power BI and your Azure SQL DB in the same region performance connectivity to the DB will be very good.




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

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

Thanks @GilbertQ  for your answer!

 

I wonder what would be different in Power BI between using Azure SQL Database and using Azure Database for PostgreSQL

I thought that it would have the same benefits as you mention (direct integration with Azure, and possibility to host to the database in the same region to have better connectivity).

 

I agree that both should work fine.

The only reason I personally would go with Azure SQL Database is there is a lot of examples of how to integrate with Power BI.

As well as a lot of resources and people who have experience on this community and others on SQL Server.




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

Proud to be a Super User!







Power BI Blog

Helpful resources

Announcements
Microsoft Build 768x460.png

Microsoft Build is May 24-26. Have you registered yet?

Come together to explore latest innovations in code and application development—and gain insights from experts from around the world.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

May UG Leader Call Carousel 768x460.png

What difference can a User Group make for you?

At the monthly call, connect with other leaders and find out how community makes your experience even better.

Power BI Dev Camp Session 22 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Top Solution Authors
Top Kudoed Authors