I have a MS Access database with one table having 500K rows and 30 columns.
Goal: Want to try to automate some queries and filters using Power Automate and data visualization on Power BI. (Basically I want to replace old way of exporting to Excel and creating pivot tables).
Please help what is my option to move data from MS Access to Power Platform?
Any connectors? (NOTE: Tried exporting 500K records as SharePoint List but it is errors as too big file, so not a good option)
If you can't use a SQL Server, you can try using a MS Teams Dataverse table. Power Automate works well with Dataverse, so if you can get your data over there it will be much easier to use.
First step would be to move your data to a SQL Server database.