Forum Discussion
Optimizing Reports in Power BI: DirectQuery vs Import.
Hello Everyone, I am currently working on a report in DirectQuery mode, connected to a SQL server (Relational) with a large amount of data. Upon completing the report, each page takes between 3 to 7...
Hi, if Direct Query is important to you, I would recommend you switch to in-memory DWH. We did it at my company, as we realized that SQL Server is not fast enough for this purpose. We tried several in-memory DBs and decided on Exasol. The good thing about it was that we could use Exasol as an acceleration layer on the top of SQL Server in the beginning. After some time, we were happy with the performance and decided completely to replace SQL server with Exasol. However, if import and regular refresh is an option for you and you do not have a large dataset, then you probably do not need an in-memory DB.