Office 365 – PowerApps – Table ‘[dbo].[TABLE]’ does not define any key columns.

Today I connected my PowerApp to a SQL database in Azure. Then When I tried to connect my data I got the following

There was a problem adding your data source. Please try again

A bit of an unclear message and the try again isn’t going to help either.

KeyColumn

When looking at the details of the error things became a bit clearer:

 

Table ‘[dbo].[TABLE]’ does not define any key columns.

Session ID: b6b3017a-1ae5-a4ac-2af3-3f36837e68b6

I added a primary key to my table and the problem disappeared and I was able to add my data source.

Advertisements

Please leave a comment or feedback

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.