Updated data not showing on published report but latest data showing inside Desktop report

[Dayanand123]

Hello,

I have access data from sugar using public URL and report publish to power bi service. when data has changes sugar then updated values not refresh on power bi service report.

Thanks in advance.

[V-lianl-msft · Accepted solution]

Hi @Dayanand123 ,

You can configure Power BI to automatically refresh your uploaded report. You can also refresh the dataset on demand in Power BI. Follow the steps below to schedule refreshes through the API Server:

1. Log into Power BI.
2. In the Dataset section, right-click the Sugar CRM Dataset and click Schedule Refresh.
3. If you are hosting the API Server on a public-facing server like Azure, you can connect directly. Otherwise, if you are connecting to a feed on your machine, you will need to expand the Gateway Connection node and select a gateway, for example, the Microsoft Power BI Personal Gateway.
4. In the settings for your dataset, expand the Data Source Credentials node and click Edit Credentials.
5. Expand the Schedule Refresh section, select Yes in the Keep Your Data Up to Date menu, and specify the refresh interval.

https://www.cdata.com/kb/tech/sugarcrm-odata-power-bi.rst 

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem#types-of-gateways 

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