topic SSIS/ SSRS/SSAS confusions in Report Server

SSIS/ SSRS/SSAS confusions

capricon — Mon, 11 Mar 2024 12:44:28 GMT

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 😞

Re: SSIS/ SSRS/SSAS confusions

Anonymous — Tue, 12 Mar 2024 01:33:32 GMT

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.

Re: SSIS/ SSRS/SSAS confusions

capricon — Tue, 12 Mar 2024 04:05:35 GMT

Anonymous thanks for reply

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

Re: SSIS/ SSRS/SSAS confusions

Anonymous — Tue, 12 Mar 2024 05:25:44 GMT

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.