3

Like a refresh data menu in Power BI desktop.

Like a refresh data menu in Power BI desktop. I have exported these datasets from SQL Server database by running stored procedure query.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
Sanjay
  • 191
  • 3
  • 17

2 Answers2

1

Unfortunatly not.

The most specific API to refresh data is "Refresh Dataset In Group" but it will update the full dateset. https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/refresh-dataset-in-group

Alex
  • 73
  • 1
  • 8
  • Hi Alex, thanks for your response. Yeah, I'm aware of it but I want to know is there any way to refresh the table programmatically? – Sanjay Dec 08 '21 at 03:54
1

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.

Community
  • 1
  • 1
GregGalloway
  • 11,355
  • 3
  • 16
  • 47
  • Hi GregGalloway, thanks for your response. I'm not using Analysis Services. I'm using SQL Server for retrieving the data for the dataset. This solution seems for the Analysis Services Tabular model. – Sanjay Dec 10 '21 at 13:14
  • @Sanjay it uses the same XMLA protocol and tools as you would with Analysis Services but you are managing datasets on Power BI Premium. See the link I mentioned above. Are you on Power BI Premium? (Workspaces have a diamond icon) – GregGalloway Dec 10 '21 at 14:33