cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Power Participant
Power Participant

Re: PowerApp - Connect to access web app data

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

Highlighted
New Member

Re: PowerApp - Connect to access web app data

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 ?

Advocate I
Advocate I

Re: PowerApp - Connect to access web app data

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:

 

[ODBC]
DRIVER=SQL Server Native Client 11.0
UID=(username)
Pwd=(password)
Encrypt=yes
DATABASE=(database name)
SERVER=(servername)

 

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

Highlighted
Power Participant
Power Participant

Re: PowerApp - Connect to access web app data

Hi, actually an even simpler version of the connection string works for me and others, maybe you could try that

 

Server=tcp:MYSERVER.database.windows.net;Database=MYDATABASE;User ID=DBUSER;Password=DBPASSWORD

See this post for example https://powerusers.microsoft.com/t5/PowerApps-Forum/Data-from-SharePoint-lists-not-loading/m-p/3212#...

Highlighted
New Member

Re: PowerApp - Connect to access web app data

Thanks, this one works for me!

Highlighted
Helper I
Helper I

Re: PowerApp - Connect to access web app data

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

Highlighted
New Member

Re: PowerApp - Connect to access web app data

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.

Highlighted
Community Champion
Community Champion

Re: PowerApp - Connect to access web app data

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.

Highlighted
Regular Visitor

Re: PowerApp - Connect to access web app data

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

 

https://techcommunity.microsoft.com/t5/Office-Retirement-Blog/Updating-the-Access-Services-in-ShareP...

Highlighted
Regular Visitor

Re: PowerApp - Connect to access web app data

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

Announcements
August 2020 Community Challenge: Can You Solve These?

August 2020 Community Challenge: Can You Solve These?

We're excited to announce our first cross-community 'Can You Solve These?' challenge!

secondImage

Return to Workplace

Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.

secondImage

Super Users Coming in August

We are excited for the next Super User season.

secondImage

Community User Group Member Badges

FIll out a quick form to claim your community user group member badge today!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Top Solution Authors
Top Kudoed Authors
Users online (6,410)