locked
Analysis Services Vs Power BI RRS feed

  • Question

  • I know Power BI desktop can also build data model directly from data source like SQL datawarehouse .

    so how/what to consider  to choose between building data model in Analysis Services or in Power BI Desktop ??

    ?

    Tuesday, May 5, 2020 2:49 AM

Answers

  • Hello,

    Here are the differences between building data models:


    Reference: Choosing to model in Power BI vs Azure Analysis Services tabular

    Hope this helps. Do let us know if you any further queries.

    ----------------------------------------------------------------------------------------

    Do click on "Mark as Answer" and Upvote on the post that helps you, this can be beneficial to other community members.

    Tuesday, May 5, 2020 5:24 AM
  • Hello,

    SQL Server Analysis Services Tabular model, Azure Analysis Services, and Power BI share the same underlining fundamentals and principles. They are all built using the tabular model which was first released on SQL Server in 2012.

    SQL Server Analysis Services Multi Dimension is a different architecture and is set at the server configuration section at the install point.

    The Analysis Service Tabular model (in Power BI) is built on the columnar in-memory architecture, which forms the VertiPaq engine.

    At processing time, the rows of data are converted into columns, encoded, and compressed allowing more data to be stored. Due to the data being stored in memory the analytical reporting delivers high performance, versus retrieving data from disk-based systems. The purpose of in-memory tabular models is to minimize read times for reporting purposes. Again, understanding the consumer reporting behavior is key, tabular models are designed to retrieve a small number of columns. The balance here is that when you retrieve a high number of columns, the engine needs to sort back into rows of data and decompress, which impacts compute.

    Hope this helps. Do let us know if you any further queries.

    ----------------------------------------------------------------------------------------

    Do click on "Mark as Answer" and Upvote on the post that helps you, this can be beneficial to other community members.

    • Marked as answer by sakurai_db Thursday, May 7, 2020 3:41 PM
    Thursday, May 7, 2020 9:01 AM

All replies

  • Hello,

    Here are the differences between building data models:


    Reference: Choosing to model in Power BI vs Azure Analysis Services tabular

    Hope this helps. Do let us know if you any further queries.

    ----------------------------------------------------------------------------------------

    Do click on "Mark as Answer" and Upvote on the post that helps you, this can be beneficial to other community members.

    Tuesday, May 5, 2020 5:24 AM
  • so for size , the difference is that .

    Analysis Services, Dataset are stored in Analysis Services?

    Power BI , Dataset are stored in Power BI ? (IMPORT) ?

    what about if the dataset in Analysis Services is 100GB , and use Power BI to connect Analysis Services using import ?

    Tuesday, May 5, 2020 9:44 AM
  • anyone has the idea?
    Wednesday, May 6, 2020 4:13 PM
  • Hello,

    SQL Server Analysis Services Tabular model, Azure Analysis Services, and Power BI share the same underlining fundamentals and principles. They are all built using the tabular model which was first released on SQL Server in 2012.

    SQL Server Analysis Services Multi Dimension is a different architecture and is set at the server configuration section at the install point.

    The Analysis Service Tabular model (in Power BI) is built on the columnar in-memory architecture, which forms the VertiPaq engine.

    At processing time, the rows of data are converted into columns, encoded, and compressed allowing more data to be stored. Due to the data being stored in memory the analytical reporting delivers high performance, versus retrieving data from disk-based systems. The purpose of in-memory tabular models is to minimize read times for reporting purposes. Again, understanding the consumer reporting behavior is key, tabular models are designed to retrieve a small number of columns. The balance here is that when you retrieve a high number of columns, the engine needs to sort back into rows of data and decompress, which impacts compute.

    Hope this helps. Do let us know if you any further queries.

    ----------------------------------------------------------------------------------------

    Do click on "Mark as Answer" and Upvote on the post that helps you, this can be beneficial to other community members.

    • Marked as answer by sakurai_db Thursday, May 7, 2020 3:41 PM
    Thursday, May 7, 2020 9:01 AM
  • apart from size limitation on putting model in azure analysis servers or power BI .

    Can I achieve to model the same model in Power BI as in azure analysis service?

    for example any DAX query can only be used when build model in azure analysis service?

    Thursday, May 7, 2020 3:43 PM
  • anyone has the idea ?
    Friday, May 8, 2020 2:05 AM
  • anyone has the idea?
    Tuesday, May 12, 2020 1:10 AM