I can run my Power BI report fine on the desktop. It connects to an Azure SQL table. I connect as 'Direct query' with a username and password.

Once I publish the report, I got the following error message:

The datasource xxxxx is missing credentials and cannot be accessed.

There is a 'show details' link that opens a dialog which itself has a link to 'xxxx dataset settings page'. However that page never ends loading and remains empty.

My post is surely redundant with this one but the only answer there doesn't help and the post lost traction.