With the reference to Power BI Super Users Workshop >> Data Modeling >> Introduction to data modeling.
We have a lot of raw excel files and each file has excel sheets.
Excel file which has IT assessment tracking file and each sheet has Hardware, Computers, Software, Printers, Mobile etc.
Obviously, have raw information with no index files defined.
Q: Is it best to define index fields (lookup table) and clean it up (for e.g. wrong date formats, blank rows etc.) in Excel file FIRST and then import in Power BI desktop and assign relationships?