Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
58 | |
20 | |
18 | |
18 | |
9 |