filtering values in a column after it is expand from a related table becomes very slow

[blueant]

Hi, I get data from dynamics 365 for sales by Odata feed. 

The lead table is selected and I also need the parent account information of it. so I expanded several columns of the parent account table. then I want to filter by e.g. the status of the account, just remain the active ones. 

However, the process becomes very very slow.

I am now wondering if I just load the lead and account separately, set relationship between them, filter the account table first and then merge it into the lead table. Wil it be quicker?

[v-yuta-msft · Accepted solution]

Hi blueant,

Click File-> Options and settings-> Options. Then click the options like below:

 

Regards,

Jimmy Tao

[quentin_vigne]

Hi @blueant

You are using a direct query connection right ? 

If so, to counter the lack of performance, you need to recude your table to the needed column only. (You can edit the query so that you don't use the columns)

Else maybe you can import the data ? If they are too big maybe you can filter them before importation with a date filter (like if you have sales since 1990 maybe you don't need sales before 2010)

For what you want to try, I don't know if it will solve the problem because the lead table will be huge.

- Quentin