Forum Discussion

capricon's avatar
capricon
Regular Visitor
2 years ago
Solved

SSIS/ SSRS/SSAS confusions

hi  I want to know about  MS Report builder  MS SQL Server Mobile Report Publisher  POWER BI Report builder Power bi desktop version    Now i want to to practise SSRS / SSIS/ SSAS with power b...
"SSAS"
@PowerBI Report Server
SSIS
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi capricon ,

    I'am sorry,  each tool can be adapted to different situations, depending on the type of report the user wants to create, etc.

    To SSIS: SSIS you need to use other tools to use, for example: SSMS.

    To SSRS: SSRS allows the creation of paged reports (traditional tabular reports) and Power BI reports (interactive visualizations). If you want to analyze data , you can choose to download power bi desktop(RS).

    To SSAS: Power BI Desktop can connect to SSAS models.

    Best Regards,

    Xianda Tang

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

capricon's avatar
capricon
Regular Visitor
2 years ago

Anonymous thanks for reply

 

so  u mean for SSIS/ SSRS/ SSAS i can use power bi desktop version ? and sql server database ? right ?

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi capricon ,

I'am sorry,  each tool can be adapted to different situations, depending on the type of report the user wants to create, etc.

To SSIS: SSIS you need to use other tools to use, for example: SSMS.

To SSRS: SSRS allows the creation of paged reports (traditional tabular reports) and Power BI reports (interactive visualizations). If you want to analyze data , you can choose to download power bi desktop(RS).

To SSAS: Power BI Desktop can connect to SSAS models.

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.