cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
ziyi Frequent Visitor
Frequent Visitor

Is there an API for refresh data immediately ?

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.

Selection_317.png

 

1 ACCEPTED SOLUTION

Accepted Solutions
sananthv
Advisor

Re: Is there an API for refresh data immediately ?

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/

3 REPLIES 3
sananthv
Advisor

Re: Is there an API for refresh data immediately ?

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 Frequent Visitor
Frequent Visitor

Re: Is there an API for refresh data immediately ?

Thank you sananthv !!

I will try implement it. Smiley Very Happy

 

 

 

ZappySys Regular Visitor
Regular Visitor

Re: Is there an API for refresh data immediately ?

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.