Forum Discussion
Poor Performance with Inner Joins
I am trying to limit the amount of editing I have to do when I update reports to include new periods. There are no date fields in the data sources where I am pulling, so the periods are chosen as a l...
I saw your post in the Access thread and another you posted several hours past that was not answered yet. I see the commonality of your post is really about slow performance.
What I would do is a sanity check. Verify your PBI Desktop install is 64bit and on a machine with a good amount of RAM. Then I would start a brand new .pbix file with just 1 record set and do a Get Data load of it. And do a time trial.
Incrementally time the load only by 1 data set at a time before setting up joins or Query Editor tasks - then retime after query editing; and try and determine where is the key time delay experience.