Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.
Hi
I have a dataset with multiple Database connections (Oracle DB & Microsoft DB) and having queries with Import and Direct connectivity.The overall report is working good and refreshing also completed properly in desktop but I am facing some errors especially the visuals using fields from the direct query connection.
Error :
1.An exception occurred due to an on premise service issue.
2.Visual has exceeded the available resources.
Please help which is actually causing this issue.
Solved! Go to Solution.
Hi @Anonymous ,
According to the survey, it's the concurrency limit that's the problem.
There are multiple ways to workaround the throttling/timeouts caused by max concurrent DQ connections limit:
1. Move to larger SKU which has higher limits on Max concurrent DirectQuery connections (per semantic model) as per https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-what-is#semantic-model-sku-limitation.
2. Use DirectLake mode instead of DirectQuery to SQL endpoint. Learn about Direct Lake in Power BI and Microsoft Fabric - Power BI | Microsoft Learn Keep in mind the limitations of using DirectLake mode if you are using T-SQL views.
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
According to the survey, it's the concurrency limit that's the problem.
There are multiple ways to workaround the throttling/timeouts caused by max concurrent DQ connections limit:
1. Move to larger SKU which has higher limits on Max concurrent DirectQuery connections (per semantic model) as per https://learn.microsoft.com/en-us/power-bi/enterprise/service-premium-what-is#semantic-model-sku-limitation.
2. Use DirectLake mode instead of DirectQuery to SQL endpoint. Learn about Direct Lake in Power BI and Microsoft Fabric - Power BI | Microsoft Learn Keep in mind the limitations of using DirectLake mode if you are using T-SQL views.
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
Hi all,
We have seen on the internal platform that other engineers have reported this issue and submitted it.
The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient.
Best regards.
Community Support Team_Scott Chang
Hi @Anonymous ,
It looks like you're using mixed connection mode, I think the main reason is that you're not creating full connections for them, make sure the gateway is working properly. Also the single visual exceeds the line limit.
Hope it helps!
Best regards,
Community Support Team_ Scott Chang
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Grab the queries for these visuals with Performance Analyzer and then study them with DAX Studio. Usually the issue is that a join columns has a high cardinality over 50k.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
30 | |
24 | |
22 | |
20 |
User | Count |
---|---|
57 | |
41 | |
24 | |
24 | |
21 |