Forum Discussion
Solved
Filter Based on Parameter Taking a Long Time to Process and large model size being generated.
Hi folks, I have a query that is referencing a table in Excel, full file size of workbook is only 1mb. The table itself is only 1800 rows of data and 29 columns. I am having 2 issues and I think the...
Use the Power Query Diagnostics. That will help you identify the real culprit. My money is on the Table.Nestedjoin step. Generally you do not want to do any joins in Power Query. let the data model do the work for you.
Use the Power Query Diagnostics. That will help you identify the real culprit. My money is on the Table.Nestedjoin step. Generally you do not want to do any joins in Power Query. let the data model do the work for you.
Hi Ibendlin, I accepted this as the sloution as it helped reaffirm my suspciouns. It was the couple of joins that seem to be the biggest culprits as suggested. I carried out the transformations in a different way rather than using joins and it has sped up the query. Thanks for your time!