Forum Discussion
campelliann
3 years agoPost Patron
Using SQL Server vs Access Database
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!
SQL is far superior. Access isn't even supported in the Power BI service.
1 Reply
- lbendlinSuper User
SQL is far superior. Access isn't even supported in the Power BI service.