Forum Discussion

dp106's avatar
dp106
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...
Need Help
v-piga-msft's avatar
v-piga-msft
Resident Rockstar
8 years ago

Hi dp106,

 

It seems that this error will occur if you have a single row greater than 4 MB in size. You will need to determine what the row is from your data source and attempt to filter it out or reduce the size for that row.

 

Best  Regards,

Cherry

dp106's avatar
dp106
Helper I
8 years ago

I know the cause of the error, but unable to track the row that is causing the error. It does work fine i query Subset of the dataset.

 

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

  • v-piga-msft's avatar
    v-piga-msft
    Resident Rockstar
    8 years ago

    Hi dp106,

     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

    • Rajamani's avatar
      Rajamani
      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's avatar
        dp106
        Helper I
        8 years ago
        Thanks for your repose.
        I am already using optional sql statement to fetch only the columns I need.