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
joostraaphorst's avatar
joostraaphorst
Frequent Visitor
8 years ago

Hello,

 

I've the same issue.

I calculated the maximum size of 1 row and that doesn't exceed the 600 bytes...

 

Is this issue appeared since an update in Power BI services?

 

Regards,

Joost

  • dp106's avatar
    dp106
    Helper I
    8 years ago

    Hi,

     

    I identifed records having maximum bytes (top 30) and then tried to fetch all those records in power bi (service) and it seems to working fine. It only errors when i try to fetch a larger dataset.

     

     

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

      Hi dp106,

       

      If you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

       

      Best Regards,

      Cherry

      • dp106's avatar
        dp106
        Helper I
        8 years ago
        No it’s not resolved yet. We don’t have a solution to the issue.