Showing results for 
Search instead for 
Did you mean: 
Advocate I
Advocate I

PowerApp - Connect to access web app data

Im trying to create a power app to connect to data stored in an access web app.


Is this possible?

Power Participant
Power Participant

PS It seems that there is a 256 item limit on connections to Access Web App tables but I am trying to figure this out

I have tried to connect several times over the past months via the steps you provide. (my access web app is on SP online)

If I want to use the connection, I see a 'Default' dataset.  When clicking the 'Default' dataset I get an error message: 'the tables did not load correctly, please try again'


any ideas ?

The best method I have is, enable the read/write connection within access and then create a DSN file in notepad using the following text:


DRIVER=SQL Server Native Client 11.0
DATABASE=(database name)


Save the file with the extension .dsn


You can then load this as a file data source in access or wherever to create a linked table.


As with any linked table you will not be able to edit the table design.

View solution in original post

Hi, actually an even simpler version of the connection string works for me and others, maybe you could try that;Database=MYDATABASE;User ID=DBUSER;Password=DBPASSWORD

See this post for example

Thanks, this one works for me!

Helper I
Helper I

Any update on this? I cant see the SQL Azure Data Source > New Connection option in the powerapps?

Hey, Julian. I'm late the the game since the death of AWA was just announced. I have two apps developed in AWA that we use all the time. But the system is built as a relaional db. I'm not seeing anything that addresses that. Everything looks like it is a single table app. I sure hope I'm missing something.

Community Champion
Community Champion

Hi @merrikay

Can you please elaborate on the death of AWA?  Do you have a link to any information?

We have a major app that we use all the time, this would be a disaster.

Thanks in advance.

AWAs will not allow new apps to be created starting June.  It will be removed completely starting April 2018.

yes, you can connect to the web app azure data, but will not be very useful until PowerApps can connect to a view

Helpful resources

PA User Group

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group


Demo Extravaganza Winner Announcement

Please join us on Wednesday, July 21st at 8a PDT. We will be announcing the Winners of the Demo Extravaganza!

V3_PVA CAmpaign Carousel.png

Community Challenge - Giveaways!

Participate in the Power Virtual Agents Community Challenge

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (1,936)