Switching Gateway in Power Apps

[PAVE_BI]

After I switched my connection to a different gateway from my production to the development server. It looks like my app can not reading any data from SQL. I wanted to know why this is happening and anyways that I could resolve it.

I have attached my error below.

[Mari · Accepted solution]

Hi,

Have you tried to create a new connection to see if this keeps happening?

Something that worked for me was to disable this "Enable enhanced Microsoft SQL Server connector" feature in the Preview features section. Remove the SQL connections from the app before turning this off.

[PAVE_BI · Accepted solution]

Yes thats what I did and it resolved it. Thanks a lot 🙂