Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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