I am trying to create reports with DirectQuery coming from an Azure SQL Database, however, when I try to load them in the Power BI service I get a "Cannot load model" error message. I do not have troubles creating and sharing reports with the Import method. Tha "Allow access to Azure services" option from the database is also on.
The complete message is the following:
Cannot load model
Couldn't load the model schema associated with this report. Make sure you have a connection to the server, and try again. Please try again later or contact support. If you contact support, please provide these details.