Forum Discussion
Kimball SQL Datamart vs SSAS Tabular as datasource for PowerBI
Hi lyndon5000,
To be honest, I'm not familiar with Kimball. In my opinion, I will use Power BI to connect to the data source directly unless it's necessary to load into SSAS first. Because Power BI is already a powerful analysis tool. Please refer to https://powerbi.microsoft.com/en-us/.
Regarding the advantages of loading to SSAS, I think we can leverage the power of the Server and the modeling ability. Please refer to analysis-services/tabular-models/tabular-models-ssas.
Best Regards,
Dale
Microsoft EmployeeHi lyndon5000,
To be honest, I'm not familiar with Kimball. In my opinion, I will use Power BI to connect to the data source directly unless it's necessary to load into SSAS first. Because Power BI is already a powerful analysis tool. Please refer to https://powerbi.microsoft.com/en-us/.
Regarding the advantages of loading to SSAS, I think we can leverage the power of the Server and the modeling ability. Please refer to analysis-services/tabular-models/tabular-models-ssas.
Best Regards,
Dale