Dataverse Datasource - DirectQuery - Cannot load model

Hello,

I have set up a datasource using five tables from Dataverse. I am using directquery for the first time and am getting some issues as a result (for the purposes of this report, the data needs to be updated immediately, so import is not sufficient).

The majority of the data I need is in one table, so I tried to merge the columns I require from the other tables. Other than that, I am not really doing anything at the Power Query level. There are no relationships between the tables at the moment (I actually disabled load on the other tables but have now re-enabled, in case that was causing the problem).

The data loads into the report in desktop and seems to be fine. Even when a publish to a workspace, it all seems to be fine.

I get the following issues:

In the Power BI web portal, I get the following message when trying to load the report:

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.

The dataset is refreshing each hour and seems to be working.

If I open the file in Power BI desktop, I get the following error:

Cannot load model

We couldn't connect to your DirectQuery data source or internal model. Double-check that your server and database names are correct, and that you have permissions to access them.

DirectQuery error: DirectQuery may not be used with the data source - please consider moving to a supported data source or upgrading the SQL Server data source to the latest available version.

Any help would be much appreciated.

Thanks,

Ryan