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 bi .. so on which tool should i practise ? which is latest ? 

initially first i create dataset on MS Report builder and save on cloud . like on this 

 

http://desktop-fn84eoh/RS_WP/browse

 

and then from this i use import databset on MS SQL Server Mobile Report Publisher ... but i face error like "could not connect to data"

 

so i am very much confused.. like power bu desktop has also analysis service option .. 

so please suggest some correct guideline from which tool should i start.. so many tools so much confusions 😞

"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.

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi capricon ,

    MS Report Builder:

       MS Report Builder is a powerful tool for creating paged reports, also known as SQL Server Reporting Services (SSRS) reports. It allows you to design and publish reports that can be accessed through a web portal or exported to various formats (PDF, Excel, etc.).

    MS SQL Server Mobile Report Publisher:

    • SQL Server Mobile Report Publisher is used to create mobile reports specifically designed for viewing on smaller screens (e.g., mobile devices).
    • You can connect to various data sources and create mobile reports with adjustable grid rows, columns, and flexible elements.
    • However, this tool is also deprecated starting in SQL Server 2022 and Power BI Report Server
    • If you’re interested in mobile reports, consider exploring other options like Power BI mobile reports.

    If you want to practice SSRS,SSIS and SSAS alongside Power BI , Power BI desktop is your go-to tool.

    Start with Power BI Desktop since it covers a wide range of scenarios, including interactive visualizations, data modeling, and connecting to various data sources.

    For paginated reports, use Power BI Report Builder (for Power BI service) or explore other modern alternatives.

    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.