Updating Schedule refresh for Power BI Report
Hi, As we know, Schedule refresh for Power BI report could be set manually on the UI. If we are trying to automate the setup of schedule refresh on a report instead of manually entering it, what are the optins we have - 1) Can the meta data tables ( Catalog, Subscriptions, Schedule, ReportSchedule) be used to stage entries into these tables and the schedule refresh shows up on the UI fo the report? 2) Any REST API code that could be used in a power shell script to place/update the schedule information on the report? Was able to extract Schedule from a Power BI report on Test report server to a JSOn file. Now need this information to be read from JSON file and updated to the report on Prod report sever? - REST API can do it? 3) If first and second options are not feasible, what other options are available? Also, why does this mesage popup under "Schedule Refresh" section ?
Power BI Api to get parent dataset id by report id
If I have a report which is getting data from a dataset 1 which itself is getting data from another dataset 2, how to get dataset 2 id through report id as we can only know id of dataset 1, using api getDatasets(group id, report id). Till now, I'm using an approach not very performant, which is like once I get datasource for dataset 1, I compare datasource name with all datasets database connection names, to filter out parent datasets. As you can see in above, each time a call to get all datasets is time consuming. Is there any better way to do this using either one or multiple api calls?
