Forum Discussion
Transforming Data with a Live Connection
lucas9e Yes, the closer to the source you can get those transformations, the better. You can also use Direct Query connection on Power BI datasets (preview feature - https://excelwithallison.blogspot.com/2023/01/duh-power-bi-learnings-from-microsoft.html )that will give you a bit more functionality for adding some columns and tables to the model, but won't enable transforming the analysis services data itself.
lucas9e Yes, the closer to the source you can get those transformations, the better. You can also use Direct Query connection on Power BI datasets (preview feature - https://excelwithallison.blogspot.com/2023/01/duh-power-bi-learnings-from-microsoft.html )that will give you a bit more functionality for adding some columns and tables to the model, but won't enable transforming the analysis services data itself.