Forum Discussion
Very Slow data transformation steps
Hello Community, I have a set of excel based data sets ( ~ 15 excel files with substantial data). i want to bring this data to Power BI. The data in Excel is not well structured hence after i imp...
Hello Vikas_J ,
Power query works as you do the transformation and it save the steps then everytime you refresh, it bring the data from the source and go through the applied steps.
this is how power query works, and it won't pull data without applying the steps.
If i add a transformation step to the query , for each step as minor as moving a location of a column, it is taking very long to process the transformation step. what could be the reason for this and how can i improve the speed for each step processing.