Performance issue with Direct Query with SQL Azure

[dilkushpatel]

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 query it will try to do query for each and every click and importing this amount of data also does not make sense.

So is there any way I can improve performance so that i can create viable report?

This could well be more of a Azure question but wanted to see if there is anything in power bi that can be helpfull.

just to give perspective simple select count from fact table with 7 mil records took 35 min.

Any tips for improving perfomance?

Thanks,

Dilkush