Forum Discussion

Solomon_Guy's avatar
Solomon_Guy
Advocate II
6 years ago
Solved

Salesforce Refresh - web and desktop data discrepancy

Hi all,   I have a workspace which draws data from multiple salesforce reports which isn't updating properly. When I refresh the data on the desktop version I can see the latest figures which match...
Dataflow
Need Help
  • Solomon_Guy's avatar
    Solomon_Guy
    6 years ago

    Thanks, I logged a ticket and was promptly helped by a lovely person in support Vinitha Botla. 

     

    We went through the datasets and found the problem to be a date field which was formatted as text in query editor. 

     

    After updating and republishing the missing data was visible and stable.

     

    Thanks everyone!

  • V-lianl-msft's avatar
    V-lianl-msft
    6 years ago

    Hi Solomon_Guy

     

    It's glad that you have solved your problem.
    Please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

V-lianl-msft's avatar
V-lianl-msft
Community Support
6 years ago

Hi Solomon_Guy ,

 

Refer the troubleshooting:

  • Connected with a production Salesforce account that has API access enabled

  • Permission granted to the Power BI app during sign in

  • The account has sufficient API calls available to pull and refresh the data

  • A valid authentication token is required for refresh. Salesforce has a limit of five authentication tokens per application so make sure you've five or less Salesforce data sets imported.

  • The Salesforce Reports API has a restriction that supports up to 2,000 rows of data.

 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Solomon_Guy's avatar
Solomon_Guy
Advocate II
6 years ago

Hi V-lianl-msft thanks for the tips. See my responses below

 

  • Connected with a production Salesforce account that has API access enabled

    • Confirmed API access enabled on connected production Salesforce account

  • Permission granted to the Power BI app during sign in

    • Confirmed permission is granted

  • The account has sufficient API calls available to pull and refresh the data

    • Confirmed sufficient API call available

  • A valid authentication token is required for refresh. Salesforce has a limit of five authentication tokens per application so make sure you've five or less Salesforce data sets imported.

    • Exactly 5 data sets are being used

  • The Salesforce Reports API has a restriction that supports up to 2,000 rows of data.

    • The dataset in question has <2000 rows. 

 

Any other potential suggestions? I'm running out of ideas. 

  • V-lianl-msft's avatar
    V-lianl-msft
    Community Support
    6 years ago

    Hi Solomon_Guy ,

     

    You could create a support ticket for more help. If you have a Pro account it is free.
    https://powerbi.microsoft.com/en-us/support/

     

    Best Regards,
    Liang
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

    • Solomon_Guy's avatar
      Solomon_Guy
      Advocate II
      6 years ago

      Thanks, I logged a ticket and was promptly helped by a lovely person in support Vinitha Botla. 

       

      We went through the datasets and found the problem to be a date field which was formatted as text in query editor. 

       

      After updating and republishing the missing data was visible and stable.

       

      Thanks everyone!

      • V-lianl-msft's avatar
        V-lianl-msft
        Community Support
        6 years ago

        Hi Solomon_Guy

         

        It's glad that you have solved your problem.
        Please accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

         

        Best Regards,
        Liang
        If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.