Forum Discussion
How Data Refresh programmatically?
lbendlin wrote:
I never know if a question posted in the report server section is actually related to report server. The "catalog" wording should have been my hint to leave this alone as I have no experience with report server.
🙂 it can be hard to tell. A lot of people do not differentiate between "Server" and "Service"
lbendlin wrote:
Is there a way to use the SQL scheduler?
Not easily, the SQL agent jobs are created with Schedule GUID so you are faced with the orignal issue of having to link a ScheduleID and a catalog item
MeiSalas wrote:
Is there a way to do a Data Refresh just by knowing the Catalog Item? Without doing a Schedule?
No, for the on-prem Report Server you can only trigger a refresh via a schedule. Note that you can create a schedule with a one off date in the past and trigger that, but there is no API to refresh with just the catalog item reference.
lbendlin - Power Automate is a great solution for the cloud service, but it's not a solution for the on-prem Report Server.
d_gosbell noted. I never know if a question posted in the report server section is actually related to report server. The "catalog" wording should have been my hint to leave this alone as I have no experience with report server.
Is there a way to use the SQL scheduler?
lbendlin wrote:
I never know if a question posted in the report server section is actually related to report server. The "catalog" wording should have been my hint to leave this alone as I have no experience with report server.
🙂 it can be hard to tell. A lot of people do not differentiate between "Server" and "Service"
lbendlin wrote:
Is there a way to use the SQL scheduler?
Not easily, the SQL agent jobs are created with Schedule GUID so you are faced with the orignal issue of having to link a ScheduleID and a catalog item
