Showing results for 
Search instead for 
Did you mean: 
Not applicable

[BUG] "Bad data source - not a valid data source" error after moving app from one environment to another

I am getting the above error when moving an app from one environment to another.


My app is a canvas app with one connector, to SQL Server, using SQL authentication. 


I created this app in my development environment, and once it was ready for testing I exported it and then imported it in to our test environment, where the SQL Server connector already existed. On import I said create new application (although it also happens when updating) and then selected the correct SQL Server connector as part of the import process.


When I open the app in the editor I get two runtime errors, as in the title of this post:


The requested operation is invalid.
Server Response: Bad Data Source.
     inner exception: Not a valid data source.
clientRequestId: .....


If I remove the data source and re-add it everything works fine, but I shouldn't have to do that. This same issue will arise when I move from test -> production, and clearly you should not be editing apps when they are promoted to production - this invalidates every ALM principle ever.

Not applicable

Can someone please take a look at this? It's hugely frustrating

Not applicable

This is still happening. I hate PowerApps.


It looks like disabling the advanced sql connector feature fixes things, so way to go. Great enhancement there. Well tested.

Helpful resources

UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power Apps Community Call Jan. 2022 768x460.png

Power Apps Community Call

Please join us on Wednesday, January 19th, at 8a PDT. Come and learn from our amazing speakers!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors
Users online (1,651)