cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Steelman70
Level 10

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

Bitwize_PowerBI
Level: Powered On

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 ?

VinnyClegg
Level: Powered On

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

Steelman70
Level 10

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#...

Bitwize_PowerBI
Level: Powered On

Re: PowerApp - Connect to access web app data

Thanks, this one works for me!

RK
Level: Powered On

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?

merrikay
Level: Power Up

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.

Meneghino
Level 10

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
sylvanexit
Level: Powered On

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...

sylvanexit
Level: Powered On

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
thirdimage

Power Automate Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

fifthimage

Microsoft Learn

Learn how to build the business apps that you need.

Top Kudoed Authors
Users Online
Currently online: 463 members 6,562 guests
Please welcome our newest community members: