Is there an API for refresh data immediately ?

[ziyi]

I have created a custom visual which data source is an Azure SQL.

The custom visual includes a HTML form and users can post data to the SQL database via the webapp.

It works fine.

Then, I want to refresh the custom visual as soon as user's action.

Is there a way to refresh the custom visual programmatically ?

Ok, I know the referesh button are on the screen above, but I want to do it programmatically.

[ZappySys]

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.

https://zappysys.com/blog/refresh-power-bi-dataset-via-rest-api-using-ssis/

If you dont use ETL Tool and want to call API from SQL Server (T-SQL) then may be use appraoch documented here.

https://zappysys.com/blog/import-rest-api-json-sql-server/

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.

[sananthv · Accepted solution]

Create an onload event to call the data refresh API? this is just a thought.  https://powerbi.microsoft.com/sv-se/blog/announcing-data-refresh-apis-in-the-power-bi-service/

[ziyi]

Thank you sananthv !!

I will try implement it. 😄