How to Lookup/ reference between Excel table and Power Pivot


Is it possible to perform, in Excel 2016, a Lookup from an Excel table (through Vlookup, other lookup/ reference functions, or its DAX equivalent Lookupvalue) into the data model (Power Pivot)?
My goal is to retrieve values from the data model into an Excel table.

The Excel table is composed of several thousands row. Each row needs to retrieve through Lookup/ reference functions a value from a table in the data model.
What would be the way to make this process the most efficient possible, from a time and resources perspective?

For example, is it possible to perform the lookup only when certain cell change?
What are the lookup and reference functions that are the most efficient?
If several hundreds of Lookups are to be performed simultaneously, how to optimize? VBA, existing tools?

Many thanks
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Paul NeralichBusiness OwnerCommented:
NBA, If I understand correctly, you might benefit from a free download called DAX Studio as well as this video:
The video's titled is "DAX Query to Export Data from Data Model to Excel Sheet"
At about minute 9, reference is made to the DAX "RELATED" command, which I think is akin to a regular VLOOKUP command in Excel.

DAX Studio is available from

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
NBAAuthor Commented:
Hi Paul,

Thanks a lot for your answer.
It actually solved more than one question I had :-)

It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.