Local Server Dataset Refresh Not Scheduled

zander1976 — Mon, 07 Mar 2022 14:52:50 GMT

Good Morning,

We are running powerbi local report server in combination with SSAS, SQL and Oracle. In the background, we have a complicated date pipeline that uses Airflow for orchastration. The data pipeline breaks on a regular bases (not all in our control) so we only want to update the dataset after all stages have completed successfully.

Can we trigger a dataset refresh from either Powershell ReportingServicesTools or the rest API? The reports used import instead of liveconnect or direct query. Any ideas would be greatly apprecieated.

Thank you,

Re: Local Server Dataset Refresh Not Scheduled

d_gosbell — Mon, 07 Mar 2022 21:15:28 GMT

You could use the technique I posted here https://community.powerbi.com/t5/Report-Server/Refresh-Power-BI-using-company-scheduler/m-p/987057#M13558 to trigger a refresh using a POST to the REST API

topic Re: Local Server Dataset Refresh Not Scheduled in Report Server

Local Server Dataset Refresh Not Scheduled

Re: Local Server Dataset Refresh Not Scheduled