Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
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?
Solved! Go to 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
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
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!
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
Check out the July 2025 Power BI update to learn about new features.
User | Count |
---|---|
25 | |
18 | |
18 | |
13 | |
12 |
User | Count |
---|---|
35 | |
22 | |
21 | |
18 | |
12 |