In regards to best practices when setting up a Data Model, when the excel files you are working with contain multiple vlookup and xref columns. How does PowerBI handle the upload of that vlookup & xref data?
Some potential solutions I’ve come across are
1.Creating a new excel, copying and pasting all the data as values then importing that into Power Bi. (though I feel this leads into more trouble in the future)
2.Importing the basefile and creating multiple LOOKUP columns based on reference tables imported into PowerBi to mimic what is done in Excel.
Is there an option I’m missing or a general best practice for situations like these? Thanks in advance!