Not sure why this appears to be so difficult (Probably just me)
I have previously created data sets which come from Salesforce.com - some are Objects (Account, Opportunity, etc.) and others are reports. I am in the process of cleaning up some obsolete fields in Salesforce but since they were part of the data source that I initially defined in Power BI, if I simply delete them from Salesforce then the refresh and sync will fail.
I have tried to go into Power BI (Desktop) and Remove the fields from the query first but when I delete the field it give me an error saying that the field can't be found in the table? I've gone round and round and can't see why what should be a simple task is not working!
Goal: Delete fields in Salesforce object - Refresh and Sync in PowerBI don't break!