How to limit the number of rows from a DB data source

[Anonymous]

I've searched for an answer and can't find one.

In Desktop, I have added a fact table to my list of data sources. The table contains >3M rows by 272 columns. I'd like to get just the most recent records. I tried creating a new query, but it won't return anything. I'm using Oracle as the data source. This is the query I tried just to see if I could get fewer than 3M rows, but need to use the current date as the filter.

select ln_record_type, cost_cntr from cpxxdm.ln_cpxxdm_daily where rownum <= 5000 ---- wasn't sure if I needed the semi-colon, so tried with and without to no avail.

Thank you.

[v-yulgu-msft · Accepted solution]

Hi @Anonymous,

When you create a data source connection string, you can input the Oracle query meanwhile to filter returned records.

To ensure the query is correct, please run it in Oracle DB first.

Regards,

Yuliana Gu