Forum Discussion

edchuy's avatar
edchuy
Advocate V
6 years ago
Solved

Can't connect to Salesforce Objects

There is currently an issue that causes access to Salesforces Objects to get errors of the type "Access is forbidden". I can't refresh data from those tables nor can I even get access to new objects. I have tried using Power Query in Excel and to refresh the same data in the Power BI service to no avail. The problem seems to have started about 3 days ago and I have been able sporadically to refresh the data. I had not had this problem previously.

  • edchuy's avatar
    edchuy
    6 years ago

    It turns that our license to Salesforce has a limit to how many transactions (or something along those lines) can be requested within a certain time frame. I was refreshing my report each hour and a half which consumed our company's quota after a few refreshes.

3 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Community Support

     Hi edchuy ,

     

    Could you please try to connect salesforce in a new power bi report, if the problem is still exist, try to "File" - "Options and settings" - - "Data Sources Settings", find the salesforce, then re-enter your correct credentails.

     

    In Power BI Service, enter "Settings" - "Dataset", find the dataset using salesforce, re-enter the credentails in "data source credentails", then try to refresh again.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • edchuy's avatar
      edchuy
      Advocate V

      It turns that our license to Salesforce has a limit to how many transactions (or something along those lines) can be requested within a certain time frame. I was refreshing my report each hour and a half which consumed our company's quota after a few refreshes.