Skip to main content

Notifications

Power Automate - Using Connectors
Unanswered

Have a table in MS Access with 500K records and 30 columns. How should i get this data to Power Platform to eventually view it on Power BI?

(0) ShareShare
ReportReport
Posted on by

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)

  • wskinnermctc Profile Picture
    wskinnermctc 6,512 on at
    Re: Have a table in MS Access with 500K records and 30 columns. How should i get this data to Power Platform to eventually view it on Power BI?

    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.

  • lbendlin Profile Picture
    lbendlin 7,609 on at
    Re: Have a table in MS Access with 500K records and 30 columns. How should i get this data to Power Platform to eventually view it on Power BI?

    First step would be to move your data to a SQL Server database.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Microsoft Kickstarter Events…

Register for Microsoft Kickstarter Events…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Announcing Forum Attachment Improvements!

We're excited to announce that attachments for replies in forums and improved…

Leaderboard

#1
WarrenBelz Profile Picture

WarrenBelz 145,666

#2
RandyHayes Profile Picture

RandyHayes 76,287

#3
Pstork1 Profile Picture

Pstork1 64,996

Leaderboard

Featured topics