Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Slow Applying Query Changes

Hello,

 

I have a data model that contains 3 tables, 1 fact table and 2 dimension table. I have applied the basic relationship using one to many. I have filtered the needed requirements and columns as well. The thing is when i click close and apply, the apply query changes is taking too long to load the data. It's really slow like it would take 1-2 hours to finish loading the model for 1 table that i have changed.

 

Is there a way to speed up things? The data source is SQL (through OLEDB conection), 2 local excel files as reference.

 

Thanks for the help..

Need Help
Show and Tell

4 Replies

  • amitchandak's avatar
    amitchandak
    Super User
    5 years ago

    Anonymous , Try these setting in data load, under file-> options and setting -> Option -> report level

    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Hello, thanks for the tip. It did not give much of a difference. I have 128 columns in my main table. Is it because i have lots of columns that makes it slow to load the model? 

  • selimovd's avatar
    selimovd
    Most Valuable Professional
    5 years ago

    Hey Anonymous ,

     

    can you check in your steps if query folding is happening?:

    Query folding | Microsoft Docs

     

    Maybe you put a step at the beginning that is breaking query folding and you could optimize that by putting these kind of steps at the end.

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis
     
    • Anonymous's avatar
      Anonymous
      Not applicable
      5 years ago

      Not sure why you mean, but here is my steps