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
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.