Co-Pilot Agent Azure SQL Knowledge only available to user who added it

Question

Hi there,

I and one other are developing a co-pilot agent with the intention of deploying it and allowing users to make simply queries to an azure Database we have to retrieve information. I have added the database as a knowledge source via a service principal - and it has successfully connected. I am able to ask how many rows in my table etc. and it returns accurate results within the test window.

My partner however is unable to do the same. The knowledge is also showing as ready inside his copilot studio, but when he asks the same question the bot returns a suggested SQL query and not the answer.

We both have access to the underlying data and have even tried adding the knowledge source a second time from his co-pilot studio, querying it to get an accurate result, removing it and asking the same question only for bot to again return query suggestions.

What are we doing wrong? Any help would be greatly appreciated.