Hi Dale, v-jiascu-msft,
Thanks for the prompt reply -
Regarding your reply:
The error message is clear.
1. Did you change the password of your account? Nope, not changed password ever and I am clearing teh log in page of Salesforce OAuth2.
2. Was your password of your account expired? My password hasn't expired or been changed.
3. Please refer to this document for the limitations.
>>>1. Connected with a production Salesforce account that has API access enabled Check
2. Permission granted to the Power BI app during log-in Check
3. The account has sufficient API calls available to pull and refresh the data This should be the case, I have also waited until today to reset the daily API calls and the refresh still doesn't work
4. A valid authentication token is required for refresh. Ensure you have 5 or less Salesforce data sets imported, as Salesforce has a limit of 5 authentication tokens per application. I use 7 object tables in my report but only one dataset (Salesforce Objects).
The strangest thing is that the scheduled refresh previously ran smoothly refreshing daily, then at some point (I think when Salesforce went to TLS 1.1) the scheduled refreshs stopped working but a manual refresh was fine. Yesterday I upgraded to the Power BI Pro trial and the refresh stopped entirely. I am now recieving the error attached in this comment. However, my Power BI Desktop still updates Salesforce dataset (Salesforce Objects) fine.
Furthermore, in the dataset area (second image attachment) I used to have an option for Salesforce which seems to have disappeared since yesterdays failed refresh.
Again thanks for the help and any advice would be appreciated.