Forum Discussion
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 with the database. When I publish this update to web version, the dataset reverts to a previous state and the figures are no longer current.
When I redownload the PBIX from the newly published web version back to desktop and refresh, I can see the latest and correct data. Republishing back to web version again reverts the data to the outdated state.
My data connections appear to be working fine with no errors. This is only occuring for data from one salesforce report and not the others.
Please give me a hand if possible.
Cheers.
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.
9 Replies
Solomon_Guy - Are you by chance using Publish to Web? If that is the case, there is a cache delay of up to an hour. If that is not the case, make sure that you also set the report back to default in the Service after publishing as this can cause this kind of behavior.
Hey Greg,
I doubt this is a cache issue, as I can see the new data in powerbi web briefly when I publish before it reverts to the old state.
Can you please elaborate on setting the report back to default ? Not sure exactly what this means.
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.
