Forum Discussion

campelliann's avatar
campelliann
Post Patron
3 years ago
Solved

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

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