Issue refreshing composite model: An error occurred while loading the model

[Anonymous]

Hi,

Suddenly I am recieving an error when refreshing a DirectQuery connection in a composite mode (which previously was working fine):

An error occurred while loading the model. Verify that the connection information is correct and that you have permissions to access the data source.

The error is shown in Power BI desktop when refreshing the report and concequently will not load any other tables in the model.

When published, the DirectQuery connection visuals oddly seem to load correctly at irregular intervals, otherwise they just show as '(X) Can't display the visual'

Having checked the permissions for the DirectQuery dataset they seem OK, nothing has changed since last time it loaded correctly, and the XMLA setting is on read/write.

I am using Power BI desktop version 2.90.1081.0 64-bit (February 2021).

[Anonymous · Accepted solution]

Hi  @Anonymous  ,

You can try the following:

1. In addition to the XMLA Endpoint property being enabled read-write by the capacity admin, the tenant-level setting Allow XMLA endpoints and Analyze in Excel with on-premises datasets must be enabled in the admin portal. If you need to generate AIXL files that connect to the XMLA Endpoint, the tenant-level setting Allow live connections should also be enabled. These settings are both enabled by default.

2. It seems that some URLs and ports are still blocked in our firmware / agent. When we stop, it works.

According to MS, these URLs and ports need to be opened:
https://docs.microsoft.com/en-us/power-bi/admin/power-bi-allow-list-urls

This is a link to related content, I hope it will help you:

https://community.powerbi.com/t5/Desktop/Error-when-connecting-Power-BI-service-data-to-desktop/m-p/186940

https://community.powerbi.com/t5/Desktop/Share-your-thoughts-on-DirectQuery-for-Power-BI-datasets-and/m-p/1559962/page/7

https://community.powerbi.com/t5/Desktop/Error-connecting-from-Power-BI-Desktop-to-Azure-Analysis/m-p/357519

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.