DirectQuery vs Views vs Import Tables

[zeus]

What is the best practice for the scenario below.

There is a requirement for a Power BI report to be created using data from a few (at least 5) Oracle tables in 2 schemas. The data set can be fairly large and optimum performance is expected.

To create the report, which is the preferred option:

1. Import the required tables into Power BI and create the necessary joins in the BI model.
2. Use the DirectQuery option with a prebuilt SQL statement.
3. Create a view in Oracle and use that as the report data source.
4. Some other "best practice" approach.

Your input will be much appreciated.

[Anonymous · Accepted solution]

Nothing will ever beat tables in Import mode. Nothing. Forget about DQ if you want to have lightning fast caculations. Create views in your db and use the views as the source for tables. Just import the data from the views.

[zeus]

Hi daxer,

Thanks very much for your reply.