Forum Discussion
Performance enhancement tricks when using Direct Query to get data from SQL server
Hi, I am using PBI Desktop to create PBIX files which I later upload to Power BI Embedded (PaaS solution). The PBIX gets data from Azure SQL server in Direct Query mode. I want to increase the ef...
Hi aviku,
Based on my understanding both the options above will help increase the efficiency of queries, as all queries sent to the source database will run against only specific data instead of the entire table in this scenario, thus reducing the time that back-end source takes to respond.:smileyhappy:
Regards