When I go to Advanced app settings, I can't enable the Enhanced Microsoft SQL Server Connector. I get the error "Your app has a SQL data source - you must first remove any existing SQL data sources before you can toggle this feature". I've opened View > Data sources, and deleted all SQL Server sources. I've also deleted the specific SQL Server connector from Powerapps > Data > Connections. I've left it overnight in case jobs/sync's need to run but the error still appears. I have other connections in other powerapps to SQL Server so I can't remove all SQL Server connections as it will break those apps. Also when I now go to edit the app, I get a permissions issue saying I need to re-add the SQL Server connection, with an 'Allow' button greyed out.
How can I enable this setting?
Hi @angrypikachu ,
I have made a test on my side, once I delete all SQL Server Data sources, the feature can be toggled on.
So the cause of your issue may be that you haven't deleted all SQL Server Connectors.
Can you confirm that is there any flow which contains SQL Server Connector within your apps?
I have this same issue - I removed all SQL Datasources and Flows. There is nothing left to remove. I have saved and reloaded many times. - Still tells me I have an SQL data source.
Reopen responsibly, monitor intelligently, and protect continuously with solutions for a safer work environment.
Join us for an in-depth look at the new Power Apps features and capabilities at the free Microsoft Business Applications Launch Event.
Featuring samples like Return to the Workplace and Emergency Response Applications
Features releasing from October 2020 through March 2021