BIP Data Model with an Excel Data source
I have a BIP data model with an HCM SQL data set/source and an Excel data set/source, which pulls the required data successfully. However, when I refresh the excel data source the data model does not pull this data, but rather the original excel data it pulled previously. I can only pull the refreshed excel data if I manually repoint the excel data source to the same folder and file path. Is there a way to automate this so that every time the BIP data model runs it pulls the data from the refreshed excel file source?