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
Anonymous's avatar
Anonymous
Not applicable
8 years ago

Does your data contain binary type columns (i.e. files held in the data)?

  • dp106's avatar
    dp106
    Helper I
    8 years ago
    No binary fields.. all data types are varchar2. The error seems to be very random.
    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Same issue here, happend all of a sudden....

      Did you already find a solution? 

       

       

      • dp106's avatar
        dp106
        Helper I
        8 years ago
        No solution yet. Though the error message is specific to row limit. I get this error only when I fetch more rows. If I limit it to few records then no issues. I am not sure if we can track the record that is causing this issue.