Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
PshemekFLK
Helper IV
Helper IV

Power Shell Script to refresh a single table

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:

powershell.PNG

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):

 

powershell2.PNG

 

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

 

What am I missing?

 

1 ACCEPTED SOLUTION
Burningsuit
Resident Rockstar
Resident Rockstar

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.

Burningsuit_0-1673006593791.png

Hope this helps

Stuart

View solution in original post

3 REPLIES 3
Burningsuit
Resident Rockstar
Resident Rockstar

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.

Burningsuit_0-1673006593791.png

Hope this helps

Stuart

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!

@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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.