Forum Discussion
Slow data refresh
Hi, Normally my power bi file takes about 5 minutes to refresh, but now it it taking at least 30 minutes (and counting). I noticed that the refresh screen is saying that it has (currently) read s...
What was the join type?
Left outer?
Full outer?
Something else?
I would attach a screenshot of the merge but if I click on insert image I don't see a browse diaglogue to select the screenshot file.
Anyway it is a left out join referring to the same table.
The table has 3 relevent fields:
Contract number
Timestamp when contract was created
Related contract number (used if a contract relates to an earlier contract)
I'm then using the merge to create a field to show the timestamp of the "Related contract number" (where one is present)
The table has about 115,000 rows and currently the "apply query changes" dialogue box is showing 258 millions rows and counting!
Thanks,
CM