Forum Discussion

Dayanand123's avatar
Dayanand123
Regular Visitor
5 years ago
Solved

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

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.

  • 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.

1 Reply

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity Support

    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.