Hello,
I'm in need of understanding how impersonation works with a tabular model and Analysis Services Server. I have a tabular model that connects to a data source using SQL Authentication. For impersonation, I use the Service Account option. Also, the tabular model is in DirectQuery mode. From the documentation, it seems impersonation is used to fetch data from the data source and process the data on the Analysis Services Server. However, if the tabular model is in DirectQuery mode, the data is not processed or stored on the Analysis Services Server. How does impersonation work in this scenario?
Moreover, by using the Service Account option as my impersonation, does this account need to have access to the data source? I have reports that connect to the tabular model where the reports run successfully. The service account does not have access to the data source. So, I'm wondering how the reports are running successfully.
