I Have a model constructed with Power BI Desktop over salesforce data objects. I published it and schedule refresh which worked out just fine.
I also wanted to add some static data.
For instance, I have a country field in salesforce, and wanted to add a country group field according to my personal mapping. if I add this thourgh an excel local file, I can't use refresh. I tried to put it in one drive, but the desktop app doesn't seem to have a way to add it.
Does anyone have a suggestion on how to approach this?
Have you installed Personal DMG in order to schedule the local excel file?
In my opinion best is to store the excel file in onedrive (as you did ) but you need to import the data in PBI Desktop from excel using "From Web" and provide the onedrive path..This way you can refresh the excel file & salesforce since all data sources will be in online (cloud)..( not test with salesforce)
P.S. Do not just copy paste the path from browser - needs a to tweak it a bit - reference this
I have only tried it with excel powerquery many versions before..not sure if anything changed.. Double check that the folder in OneDrive plus the query settings must be public..( probably you have done this )..