We have a report that takes data from on-prem Excel spreadsheets and Salesforce. We want to schedule a refresh of this data at last once a day. We have an Enterprise Data Gateway setup and running with the latest version of the software. When we go to configure the refresh for the data Power BI asks for the data credentials to be updated because they are invalid.
Clicking on Edit credentials brings up a login screen for Salesforce. We type in our username and password, Salesforces asks for permission for Power BI to access Salesforce which we approve. Then we get the following error message: