Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!To celebrate FabCon Vienna, we are offering 50% off select exams. Ends October 3rd. Request your discount now.
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).
Solved! Go to 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:
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.
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:
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.