Forum Discussion
Salesforce Refresh - web and desktop data discrepancy
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!
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.
Hi Solomon_Guy ,
Do you have a schedule refresh configured for this dataset?
If you only use saleforce as the data source, you only need to enter the correct credentials.
You could check the refresh history to see if the refresh is complete or try to click the "manual refresh" of the dataset.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Liang, thanks for reaching out.
Manual refreshes seem to work fine. I do have a scheduled refresh set which mostly succeeds, occasional error get thrown as per below image. The error report emailed to me reads "Failure details: The last refresh attempt failed because of an internal service error. This is usually a transient issue. If you try again later and still see this message, contact support."
I have my data source set only to Salesforce logged in to a system administrator account with API calls enabled. Never had issues like this previously, however note this started to occur after our organisation upgraded to a higher subscription tier of salesforce which enabled API access. Previously we didnt have automatic dataset updates from salesforce to BI.
Any support is appreciated. Thanks!
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.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.
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.