Procore bidboard excel file to DataLake

We currently use MS Fabric to house Procore analytics; however, bidboard does not have analytics and we must download an excel file. I'd like to set up a Lakehouse to manually import these excel files and then give our data analyst access to query the information. As a bonus it would be nice to be able to set up this information to share with Salesforce. This would be our first bit of outside data that we would be able to collaborate with our Procore data so I'd like some help setting it up correctly the first time. I'd also like to set it up with the Powerbi model so that when we add a new excel file it removes duplicates and I am able to slice by month, quarter, year. and custom date range.