Forum Discussion

alexeisenhart's avatar
alexeisenhart
Icon for Resolver I rankResolver I
7 years ago
Solved

Moving Power BI Analysis into SSIS or SSAS?

Hello! I hope my question isn't too off topic.   I've been working with Power BI for a few months to build reports and it's helped me gain traction regarding our need for a more robust data warehou...
  • alexeisenhart's avatar
    alexeisenhart
    7 years ago

    A quick follow up for anyone else in my shoes who comes here later.

     

    After doing a lot of reading, it seems like the current recommended practice is to use SSIS to perform ETL and SSAS for analysis, then you can connect Power BI or another front end into SSAS.

     

    SSIS performs very basic ETL, such as standardizing gender values, converting dates to UTC, and compositing data from multiple sources. No DAX analysis.

     

    SSAS contains the DAX analysis and dataset designers that you're familiar with from Power BI. Use SSAS to do your calculations and measures.

alexeisenhart's avatar
alexeisenhart
Icon for Resolver I rankResolver I
7 years ago

A quick follow up for anyone else in my shoes who comes here later.

 

After doing a lot of reading, it seems like the current recommended practice is to use SSIS to perform ETL and SSAS for analysis, then you can connect Power BI or another front end into SSAS.

 

SSIS performs very basic ETL, such as standardizing gender values, converting dates to UTC, and compositing data from multiple sources. No DAX analysis.

 

SSAS contains the DAX analysis and dataset designers that you're familiar with from Power BI. Use SSAS to do your calculations and measures.