Importing data from data source

[Anonymous]

Hi,

I have to import data from oracle to power bi.

There are hundreds of tables and millions of rows in database, but i want only few rows.

Please help me how i can import the required rows from oracle.

Thanks in advance

[FarhanAhmed · Accepted solution]

Expand the Advance option to see the SQL Statement

[amitchandak · Accepted solution]

@Anonymous , In the connection you can give query of you choice

Also refer

https://community.powerbi.com/t5/Desktop/parameterize-connection/m-p/205900#M90712

https://radacad.com/change-the-source-of-power-bi-datasets-dynamically-using-power-query-parameters

[vanessafvg]

can you not write a sql query in the advanced box of your connection?

[FarhanAhmed]

Write the query instead of importing whole table and limit rows using rownum

select * from table where rownum<=10

[Anonymous]

Im using odbc connection,

where do i need write the query?

[FarhanAhmed · Accepted solution]

Expand the Advance option to see the SQL Statement