Forum Discussion
dp106
8 years agoHelper I
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...
jtavolaro
8 years agoRegular Visitor
I also ran into the limitations issue recently. Using direct query, with an SQL statement selecting only the needed columns. But I added a calculated field to the result, generating a URL, and this apparantly threw the record size off dramatically. It's confusing because the same formula is used for multiple reports, just this one had an issue.