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 they are interelated which is why I have grouped them together:
Hopefully this makes sense. Any help or pointing in the right direction would be appreciated.
Thanks very much,
Solved! Go to Solution.
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!