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'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.
Solved! Go to 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
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |