Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I have a data model connecting to an Oracle Database with Direct Query.
I'm not sure why, but depending on the combination of tables selected, despite all the relationships being 'Assume Referential Integrity' ticked (which should issue an inner join), the query is not being sent to the Oracle database as a single query. It appears to be broken into multiple parts.
Unfortunately, as the filters in the query are accross multiple tables, this results in an error of 'The resultset of a query to external data source has exceeded the maximum allowed size of '1000000' rows.'
If I write the SQL manually it returns just 344 rows.
Is there any way to trace what is causing PowerBI to split this into multiple SQL statements?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi @millwardt ,
Open the Power Query Editor then for each query, right click on the last applied step in the list:
If the 'View Native Query' option is greyed out, right click on the steps above until it's visible.
This will show you the SQL sent to the underlying data source.
You could capture the SQL queries being passed from Power BI to your Oracle database using your DBMS (e.g. Toad for Oracle).
For original post ,you may refer
Solved: How to gete power bi report sql (oracle database) ... - Microsoft Power BI Community
Best Regards,
Community Support Team _ Caitlyn