Organizations relaying on Power BI for data insights have top priority to keep data up-to-date.Scheduling dataset refresh keeps data up-to-date. As organization scales up Power BI, it is difficult to manage the increasing number of datasets and refresh schedules.
In this article we discuss an option to trigger refresh Power BI data via SSIS component.
Open Power BI Data Refresh Task component. Provide Power BI credentials and click on Connect. Component connects to your Power BI account and downloads all available Groups/Workspaces and datasets.
Select Dataset to be refreshed. Click on Save & Close.
Note: Use Check Refresh Status optional feature to check status of refresh.
That’s it! Run the package to trigger dataset refresh.