An Oracle table contains 100M records. Is it possible to create ad-hoc query with powerbi?

[saiteja23]

Hi All,

An Oracle Table contains 100M records. Is it possible to create ad-hoc query with powerbi?

For example, we display an option to select any date from the calendar, and based on the date, we should get 1 month or 30 days of data before or after this date. Is there a possibility for this?

Or please suggest if there are any alternatives to achieve this reporting on such a huge table.

Thank You,

Sai Teja.

[v-xiaotang]

Hi @saiteja23 

Thanks for reaching out to us.

Please check if this article helps, Best practices for using Power BI to query and visualize Azure Data Explorer data | Microsoft Docs

Best Regards,

Community Support Team _Tang

If this post helps, please consider Accept it as the solution to help the other members find it more quickly.