Canvas app with Azure SQL Database never opens, Getting your data...

[keseykid]

Hello.

I have a Canvase app that is using SQL Server connector to connect to my serverless, single instance SQL Database in Azure.

The first screen is a menu, second screen a form to create records, and the last 3 screens are for viewing the 3 tables. The app works fine in preview but when trying to launch the app it just spins and sayd "Getting your data..."

Any guidance is greatly appreciated.

[keseykid]

I'm an idiot... I never published.

[v-monli-msft · Accepted solution]

Hi @keseykid ,

Whenever you save changes to a canvas app, you automatically publish them only for yourself and anyone else who has permissions to edit the app. When you finish making changes, you must explicitly publish them to make them available to everyone with whom the app is shared.

Regards,

Mona

[keseykid]

This is helpful thanks. Not sure but for some reason this app didn't work for myself until I published it. Idk. But thanks for the reply.