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