This is the reference on how to set the refresh automation of SSAS (SQL Server Analysis Services) datasets in Power BI. The steps to follow for this exercise are as follows.
Install and configure on-premises data gateway:
The Power BI gateway links the on-premises SSAS server to the Power BI service. It should be installed on a machine that can reach the SSAS instance. After installing, you can log in using your Power BI account and configure the gateway to register it in the Power BI service.
Connect Power BI service to SSAS:
Set your dataset in Power BI to use the gateway for data refresh. Go to the dataset settings in the Power BI service and choose the appropriate gateway. Then, set up and provide your SSAS credentials to the source. Make sure to enable a live connection or import mode, depending on your use case.
Automate refresh with Power BI scheduled refresh or Power Automate:
Scheduled refresh: If your dataset is in import mode, set up a scheduled refresh in the Power BI service. Define the refresh intervals and times per your reporting needs. Power BI will refresh the dataset automatically based on your schedule.
Power Automate:
- If you wish to employ this feature with even greater flexibility, use Microsoft Power Automate (formerly Microsoft Flow).
- Implement a flow that would initiate a refresh of your dataset. You can configure the trigger to be time-based, event-based, or condition-based.
- Follow the directions in this blog post to integrate Power Automate with Power BI.
By implementing such procedures, you will be able to ensure that the refreshes above occur automatically and accurately without human intervention in order to maintain reports as up-to-date as possible.
