Forum Discussion

dilkushpatel's avatar
dilkushpatel
Icon for Helper III rankHelper III
10 years ago

Performance issue with Direct Query with SQL Azure

Hi, I'm trying to use direct query feature with data from SQL Azure DB. Now I do have quite a good amount of data in there . (one of the fact has 7 mil records)   I understand that with qirect qu...
Need Help
Show and Tell
Tips and Tricks
dilkushpatel's avatar
dilkushpatel
Icon for Helper III rankHelper III
10 years ago

Hi,

By In-memory option for database you mean importing in pbix or SQL Azure has some setting for this?

Actiually there are 3 tables with approx 7 mil each and then there are 5 dimension tables.

 

I will try importing in pbix and see how it goes.

 

Thanks,

Dilkush

andre's avatar
andre
Icon for Memorable Member rankMemorable Member
10 years ago

yes, in Azure SQL you can create in memory indexes which can potentially improve performance.