https://community.fabric.microsoft.com/t5/Developer/Is-there-an-API-for-refresh-data-immediately/m-p/665263#M19044 <P>I have created a custom visual which data source is an Azure SQL.</P><P>The custom visual includes a HTML form and users can post data to the SQL database via the webapp.</P><P>It works fine.</P><P>&nbsp;</P><P>Then, I want to refresh the custom visual as soon as user's action.</P><P>Is there a way to refresh the custom visual programmatically ?</P><P>&nbsp;</P><P>Ok, I know the referesh button are on the screen above, but I want to do it programmatically.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Selection_317.png" style="width: 211px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/157634i82ADDD1B8F96C820/image-size/large?v=v2&amp;px=999" role="button" title="Selection_317.png" alt="Selection_317.png" /></span></P><P>&nbsp;</P> Tue, 09 Apr 2019 10:13:36 GMT ziyi 2019-04-09T10:13:36Z https://community.fabric.microsoft.com/t5/Developer/Is-there-an-API-for-refresh-data-immediately/m-p/665263#M19044 <P>I have created a custom visual which data source is an Azure SQL.</P><P>The custom visual includes a HTML form and users can post data to the SQL database via the webapp.</P><P>It works fine.</P><P>&nbsp;</P><P>Then, I want to refresh the custom visual as soon as user's action.</P><P>Is there a way to refresh the custom visual programmatically ?</P><P>&nbsp;</P><P>Ok, I know the referesh button are on the screen above, but I want to do it programmatically.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Selection_317.png" style="width: 211px;"><img src="https://community.fabric.microsoft.com/t5/image/serverpage/image-id/157634i82ADDD1B8F96C820/image-size/large?v=v2&amp;px=999" role="button" title="Selection_317.png" alt="Selection_317.png" /></span></P><P>&nbsp;</P> Tue, 09 Apr 2019 10:13:36 GMT https://community.fabric.microsoft.com/t5/Developer/Is-there-an-API-for-refresh-data-immediately/m-p/665263#M19044 ziyi 2019-04-09T10:13:36Z https://community.fabric.microsoft.com/t5/Developer/Is-there-an-API-for-refresh-data-immediately/m-p/665320#M19046 <P>Create an onload event to call the data refresh API? this is just a thought.&nbsp;&nbsp;<A href="https://powerbi.microsoft.com/sv-se/blog/announcing-data-refresh-apis-in-the-power-bi-service/" target="_blank">https://powerbi.microsoft.com/sv-se/blog/announcing-data-refresh-apis-in-the-power-bi-service/</A></P> Tue, 09 Apr 2019 11:30:05 GMT https://community.fabric.microsoft.com/t5/Developer/Is-there-an-API-for-refresh-data-immediately/m-p/665320#M19046 sananthv 2019-04-09T11:30:05Z https://community.fabric.microsoft.com/t5/Developer/Is-there-an-API-for-refresh-data-immediately/m-p/665865#M19053 <P>Thank you sananthv !!</P><P>I will try implement it. <span class="lia-unicode-emoji" title=":grinning_face_with_smiling_eyes:">😄</span></P><P>&nbsp;</P><P>&nbsp;</P><P>&nbsp;</P> Wed, 10 Apr 2019 00:14:38 GMT https://community.fabric.microsoft.com/t5/Developer/Is-there-an-API-for-refresh-data-immediately/m-p/665865#M19053 ziyi 2019-04-10T00:14:38Z https://community.fabric.microsoft.com/t5/Developer/Is-there-an-API-for-refresh-data-immediately/m-p/717953#M19693 <P>As other user mentioned Power BI offer REST API to trigger manual refresh. If you use ETL tool like SSIS you can call API using this approach.</P><P>&nbsp;</P><P><A href="https://zappysys.com/blog/refresh-power-bi-dataset-via-rest-api-using-ssis/" target="_blank">https://zappysys.com/blog/refresh-power-bi-dataset-via-rest-api-using-ssis/</A></P><P>&nbsp;</P><P>If you dont use ETL Tool and want to call API from SQL Server (T-SQL) then may be use appraoch documented here.</P><P><A href="https://zappysys.com/blog/import-rest-api-json-sql-server/" target="_blank">https://zappysys.com/blog/import-rest-api-json-sql-server/</A></P><P>&nbsp;</P><P>Keep in mind there is a limit on how many times you can cll Refresh API in one day. So dont call it too many times unless needed.</P> Tue, 18 Jun 2019 15:52:14 GMT https://community.fabric.microsoft.com/t5/Developer/Is-there-an-API-for-refresh-data-immediately/m-p/717953#M19693 ZappySys 2019-06-18T15:52:14Z