cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
plk Helper I
Helper I

Cache refresh plans and API

Is there a way to attache a cache refresh plan to a report with the new REST API? I can see how to upload a report, create a refresh plan, delete existing plans on a report but not how to attach a cache refresh plan to a report?

8 REPLIES 8
Microsoft
Microsoft

Re: Cache refresh plans and API

Hi @plk,

 

All available REST APIs are listed on SwaggerHub, including how to create and execute a cache refresh plan, please have a look at below links:

Power BI Report Server REST API

SQL Server 2017 Reporting Services REST API

 

Best regards,

Yuliana Gu

Community Support Team _ Yuliana Gu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
plk Helper I
Helper I

Re: Cache refresh plans and API

Yes, I know the docs but it is not clear which call to use to associate a refresh plan with a catalog item like a report or dataset?

plk Helper I
Helper I

Re: Cache refresh plans and API

Any ideas about this? How does one attach a refresh plan to a report?

Power BI Team
Power BI Team

Re: Cache refresh plans and API

You use a POST on this API:

 

http://server/reports/api/v2.0/CacheRefreshPlans

 

inside the payload you can specify the CatalogItem you want to associate with the schedule.

plk Helper I
Helper I

Re: Cache refresh plans and API

Ok, I will try this but the documentation says that the CatalogItemPath in the payload is the path to the "item that represents the CacheRefreshPlan" which is somewhat confusing.

plk Helper I
Helper I

Re: Cache refresh plans and API

Can you give an example? I cannot get this to work at all, not the PUT/DELETE or POST.  The Path seems to want the path of the the plan but it is not clear what this is.

 

If I try:

 

Invoke-RESTMethod -Uri "$restroot/CacheRefreshPlans(Path='/replib/cache')" -Method DELETE -UseDefaultCredentials

 

Where /replib/cache is a .rdl report with a cache defined, I just get a 404 error, for example.

Power BI Team
Power BI Team

Re: Cache refresh plans and API

The CachRefreshPlans route does not except a Path argument only and ID for the specific schedule. If you know the report that you want to get the schedules for you use this API:

 

http://server/reports/api/v2.0/reports(Path='/reportName')/CacheRefreshPlans

 

that should get you all the schedules associated with that report. If your looking for a specific one you can use OData $filter operation in the URL.

plk Helper I
Helper I

Re: Cache refresh plans and API

I found the issue - the datasource for the report was misconfigured but the errors dont' mention this. You can't set a cache if the report won't actually run.

Helpful resources

Announcements
‘Better Together’ T-Shirt Contest – Winner Announced!

‘Better Together’ T-Shirt Contest – Winner Announced!

And the winner is...

Announcing the New Spanish Forum

Announcing the New Spanish Forum

Do you need help in Spanish? Check out our new Spanish community section.

April 2020 Community Highlights

April 2020 Community Highlights

Info on our Super Users, MBAS content and badges, and updates to our support articles. - Read the full Community Highlights.

MBAS Gallery 2020

MBAS Gallery 2020

Watch Microsoft Business Applications Summit sessions on-demand.

Top Kudoed Authors