Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.

Reply
Anonymous
Not applicable

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

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).

1 ACCEPTED SOLUTION
Anonymous
Not applicable

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.

View solution in original post

1 REPLY 1
Anonymous
Not applicable

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.

Helpful resources

Announcements
September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

Top Kudoed Authors