Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

powerbi an exception occurred due to an on premise service issue

Submitted by Anonymous on ‎03-18-2024 09:22 AM

I am accessing one SQL Server DB using direct query.  This report works fine for varying lengths of time but then stops working with the error AN EXCEPTIONS OCCURRED DUE TO AN ON PREMISE SERVICE ISSUE.  We checked if there was an SQL activity (backups etc.) going on to interrupt it but none.

 

We run a subscription report to track when it fails and there is no consistency. 

 

When we refresh the report it usually starts working again, sometime we have to go and refresh the connections or on premise gateway.

 

Any ideas?

Status: Investigating
See more ideas labeled with:
11 Comments (11 New)
Comments
WillDrotar
Advocate I
Advocate I
‎03-26-2025 10:24 AM

We got this as well with DirectQuery with a table visual. Something weird I noticed- on the date slicer if it's "Last [x] Months", it can be 1,2,3,4 and it works fine (it's March). It can even be "Last 1 Years" and it runs fine (2 seconds). But when we try filtering on the much smaller "This Year" it times out and produces that error.

 

Edited to add: The initial Direct Query works fine. It's after filtering on a category slicer from another table (joined by relationship) and THEN adjusting the date slicer to "This Year" that it does this for me. 

Idea Statuses