Like a refresh data menu in Power BI desktop. I have exported these datasets from SQL Server database by running stored procedure query.
Like a refresh data menu in Power BI desktop. I have exported these datasets from SQL Server database by running stored procedure query.
Unfortunatly not.
The most specific API to refresh data is "Refresh Dataset In Group" but it will update the full dateset. https://docs.microsoft.com/en-us/rest/api/power-bi/datasets/refresh-dataset-in-group
If your workspace is assigned to a Power BI Premium Capacity or Premium Per User you can use the XMLA endpoint programmatically to refresh just one table in a dataset.