Power Bi query editor take too much time to load

[mahnoor1279]

Hey everyone ,

In power query ive  create a vlookup  with  list function and after that when i choose the Close and Apply option it take soo much time for this ( currently its running from last 15 hours)

[amitchandak]

@mahnoor1279 , If this August 2022, Please check few user has faced loading issues  - https://community.powerbi.com/t5/Issues/idb-p/Issues

You can try Jul-2022 version

Next check the lookup is on a pretty big table it can take a lot of time.

Try to break that into multiple columns

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. column if needed