Forum Discussion

alm5084's avatar
alm5084
Helper II
9 years ago

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...
Need Help
CahabaData's avatar
CahabaData
Memorable Member
9 years ago

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.

alm5084's avatar
alm5084
Helper II
9 years ago

My data sources are a SQL server database and an analysis services cube, both on premises. I am importing the data into the model.

 

I tried first with only one item from the selection list, and tried merging that with one other query. It took about 20 minutes to edit the query (in the query editor) and another 20 or 30  mintues to run. With that one selection it only pulls about 70,000 rows for the second query.

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi alm5084,

     

    >> It took about 20 minutes to edit the query (in the query editor) and another 20 or 30  mintues to run. 

    I'd like to suggest you import these tables and operated in power bi(re-create the relationships and merged in power bi), it may improve the performance.

     

    Regards,

    Xiaoxin Sheng