Forum Discussion
Choose columns and filter data before modelling (Advanced source data cleanse)
i am working with a large dataset and having to complete complex operations, which means that the refresh time for this model is crazy long. I've identified that the processing time could be cut down...
sorry, to clarify, i'm looking for line 7 to line 36 to be actioned before the source is loaded to model.
I am assuming you are referring to query folding. Can you click on the steps in your applied steps and see if View Native Query is NOT greyed out in any of the steps, then becomes greyed out? If you see some that are NOT greyed out and then some that are, what is the first step you have where it is greyed out?
source + navigation are greyed out in Powerbi Desktop... actually, it's greyed out for all steps.
However, i can view the native query on the source table when viewing in DataFlow for step 2 - dbo_response = Source{[Schema="dbo",Item="response"]}[Data]) - and beyond