Forum Discussion
Power Query/ List all possible combinations from multiple lists
Hello Everyone! I am trying to create a list of all possible combinations from multiple lists. After doing research, I discovered I could use power query in excel. The steps seem very easy. However, on my work computer, power query editor takes too long to update. One simple step takes 10 minutes, even renaming a column. I then proceeded to try on my personal laptop. I turned the lists into tables. Once I click on the table to Get Data, the Get Data option is grayed out. Do I need to download something extra on my personal macbook? How do I make power query editor run faster on my work computer? Or is there a formula I can use? Thanks in advance! This would really help me to automate my report.
3 Replies
How to make it faster - it very depends on concrete query. One of many dozens related to performance topics, just to illustrate, is here Chris Webb's BI Blog: Optimising The Performance Of Power Query Merges In Power BI, Part 1: Removing Columns Chris Webb's BI Blog (crossjoin.co.uk)
CrishanaEchols Unfortunately, you can't use PQ on a Mac to create or edit queries. That functionality only work in Excel for the PC. what type of computer do you have at work? And which Excel version are you running there?
Hello and thank you for your response.! My work computer is running on Version 2112 Build 16.0.14729.20254 64 Bit. My computer is Dell. Riny_van_Eekelen
