Slow Applying Query Changes

[Anonymous]

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..

[selimovd]

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

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

Not sure why you mean, but here is my steps

[amitchandak]

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

[Anonymous]

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?