Power Shell Script to refresh a single table

[PshemekFLK]

Hello,

I'm not succeeding in refreshing a single table using a Power Shell script.

I used the script from this site: Trigger a single table to refresh in the Power BI Service – Data – Marc (data-marc.com)

When I paste the script (adjusted with my workspace, dataset and table names) in PowerShell it looks like it suceeded:

But when I go to Tabular Editor and check the last processed time on the partition of "fct_sales_update_rr" it shows that it was last processed an hour ago (which is just a regular scheduled refresh):

Obviously the changes that I made to the table are also not reflected in the report.

What am I missing?

[Burningsuit · Accepted solution]

Hi @PshemekFLK 

A couple of things to check.

1) Is the Dataset located on a Premium Capacity or Premium Per User Workspace.

2) Have you enabled XMLA Read-Write in the Capacity.

Hope this helps

Stuart

[PshemekFLK]

1) Dataset is located on the premium capacity

2) I don't have access to those settings. I will reach out to admin to see if he can change it for me

Thanks!

[PshemekFLK]

@Burningsuit

The workspace has the "Read Write" enabled yet it still didn't work. Is it possible that this is because I don't have the admin right and only admin can run it?

Thanks