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.


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.

Avatar for Pieter Veenstra

By Pieter Veenstra

Business Applications and Office Apps & Services Microsoft MVP working as a Microsoft Productivity Principal Consultant at HybrIT Services. You can contact me using

Leave a Reply

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

%d bloggers like this: