Using SQL Server vs Access Database

[campelliann]

Hi there,

I have a dataset with tables that enconpass millions of rows. Relatively narrow (20 columns) per 5 million, but the data grows fast. 

Which is more suitable for this situation, access or sql? I am more inclined to sql, because of native query, incremental refresh and direct query.

Thanks!

[lbendlin · Accepted solution]

SQL is far superior. Access isn't even supported in the Power BI service.