Refreshing a table using Iron Python Script fails
I am trying to create an Iron Python script to refresh the data tables in my report. I have had success using the following script to refresh my of my tables, but it doesn't seem to work for one particular table I have:
if myTable.IsRefreshable and myTable.NeedsRefresh:
The problem table pulls data on demand and adds columns from 7 other tables. When I refresh this table by clicking the refresh arrows in a simple visualization I made, it refreshes no problem, but using my script above (with the correct parameters) it says: "Fetching data on demand for myTable - Canceling...". Sometimes if I hit this refresh script a few times, it actually manages to succeed.
Let me know you have any ideas what could be going on!