Forum Discussion
Solved
Poor Performance using Azure SQL Database and Direct Query
Hello! I was just wondering if anyone else has experienced very poor performance using Direct Query on an Azure SQL Database. I have limited the number of rows that I am using in my queries but this ...
supton,
I am afraid that there is no way around this. Generally speaking, import models will be faster, and 500 thousand rows is not a large dataset, it is recommended that you use “Import” mode to import data to Power BI.
Regards,
Lydia
supton,
In addition to other's post, you can consider to use In-Memory technology in Azure SQL database to optimize performance.
https://docs.microsoft.com/en-us/azure/sql-database/sql-database-in-memory
Regards,
I started looking into this as it seemed like it might help lower my DTU usage. Unfortunately, you dont get any OLTP storage on the standard plan, and you need to spend more than I have to get an adequate amount of storage space on the Premium plan, if I understand properly.