You plan to create a dashboard in the Power BI service that will retrieve data from a tabular database in Microsoft SQL Server Analysis Services (SSAS). The dashboard will be shared between the…

You plan to create a dashboard in the Power BI service that will retrieve data from a tabular database in Microsoft SQL Server Analysis Services (SSAS). The dashboard will be shared between the users in your organization. The Analysis Services database has a DirectQuery connection to the SQL Server database that contains the source data. You need to ensure that the users will see the current data when they view the dashboard. How should you configure the connection to the data source?