Power Apps to SQL Server connection error Bad Data source Inner exception, Not a valid data Source

[adriancristea]

Hi,

I know there is another topic with this name (Power Apps to SQL Server connection error Bad Data... - Power Platform Community (microsoft.com), however the resolution in that topic doesn't work for me. Basically what I have noticed is that the working tables have squared brackets around the words

However, running the app with them started throwing the errors in the subject. When trying to remove and re-add the tables, they only come back without the brackets:

This screws up all my tables, if I go in and amend the table names in my formula, it works. But I have over 150 pieces of code. Not only that, but this is in UAT, I'm worried that changing the entire code and moving the app in Prod would require changing the code again.

Anyone else had this issue and how did they manage to overcome it, please?

PS. I did remove all SQL connection instances and turned off the enhanced SQL connector option in Setting, didn't help.

PPS. I so wish PowerApps would allow us to rename the connections, it would have saved me a big deal of hassle.

Thank you.

Adi

[timl · Accepted solution]

@adriancristea 

Following a recent change in the naming convention that Power Apps uses to add SQL Server tables and views, the object names no longer include the schema name and brackets (as you've discovered).

Given the number of references you have to existing table names, I would consider extracting the source code for your app and renaming the tables that you re-added to match the existing references with the brackets.

There are more details on how to do this in my post here.

http://powerappsguide.com/blog/post/how-to-rename-data-source

[adriancristea]

@timl, thanks for the answer and solution. I ended up just manually changing the datasources, thank God for being inspired enough to use collections throughout the entire app, therefore only needed to change the datasource mentions at collection creation and in the patch formulas. Still unhappy about it though, this should have been made well known and a solution to change the names provided. 

Well, that was fun, hope it helps others with the same issue.