Do I have to "double refresh" to get my data?

[Netrelemo]

Carrying on from a previous question... https://community.powerbi.com/t5/Desktop/How-do-I-count-matching-merged-records/m-p/1317768 I have a setup that counts the matching records in a related table Table 1 is merged with table 2, (left outer) 1 Record in Table 1 has many records in Table 2. I've had to hack it because it soooo slooooooooow. Seriously. Table 1 has 1,000 rows. Table 2 has 300 rows. When it come time to refresh the query, and load the data, it takes about 2 seconds per row (of table1). So I've hacked it as follows. Use Power Query in Excel rather. Load table 2 to a worksheet. Then make the merge Table2 to the local spreadsheet rather than the external datasource. The only problem is that I have no control over the sequence in which datasets load. So to be sure, I need to refresh twice.

[Greg_Deckler]

@Netrelemo - Doesn't seem right, I have done a ton of imports from various data sources and complex transformations on millions of rows of data and it has always been super fast. What are the data sources? Can you post the query code or PBIX?

[Netrelemo]

It's probably an environmental issue.... my organisation is ..... surreal. 

The data sources are cloud based SharePoint lists and cloud based third party applications. It's the SharePoint ones that are particularly bad.