Forum Discussion

Helper I

8 years ago

Direct Query limitations on single row.

Hi, I am using power BI service and report is connected to Oracle DB in direct query mode. On-Premise gateway is installed on my local desktop as test. When i access the report i get the b...

Resident Rockstar

8 years ago

Do we have any kind of logging to trace the the record that is causing the error ?

You need to find the column which contains large size in your Oracle DataBase and reduce it.

Best Regards,

Cherry

Frequent Visitor

8 years ago

Hi,

I had the same issue. Try using optional sql statement in the getdata window which will fetches only required columns instead of entire table. This resolved my issue. hope this helps.

dp106
Helper I
8 years ago
Thanks for your repose.
I am already using optional sql statement to fetch only the columns I need.
- SeanB
  Frequent Visitor
  8 years ago
  We also have been experiencing the same issue for the past 3 days. Been trying to work with support but they have been a trainwreck. Initally they didn't respond to my request for assistance for for several hours when first reported on Tuesday morning. They then set up skype meeting with my dev team and their dev team for Wed morning at 10am - to which they were a no show. They then contacted me 3hrs later stating they were sorry for missing the meeting but this issue was due to the current disruptions they were experiencing and these issues should be resolved by 8pm EST on 8/1. Fast forward to today, issue still exists and just got disconnected from a support call I was on hold for nearly 2 hrs.
  
  We had not made any changes to our reports prior to this issue. Issue is not intermittent, occurs everytime.
  - dp106
    Helper I
    8 years ago
    Thanks for sharing your experience.
    
    Please update if you find any solution, should help us all.