Difference
between Tabular Models and PowerPivot in SQL Server 2012
-
S.No Tabular ModelsPowerPivot1Scalability:i.No specified upper size limitii.Partitions to process large volumes of dataiii.Supports Direct Query and VertiPaqScalability:i. 2 GB Excel file size limit (for uploading to SharePoint)ii. No partitioningiii. VertiPaq only2 Manageability:SSMS, AMO, ADOMD, XMLA, Deployment Wizard, PowerShell, Integration ServicesManageability:Excel / SharePoint3 Securability:Row level and dynamic securitySecurability:Excel workbook file security4 Deveolopment Tool:Visual StudioDeveolopment Tool:Excel
No comments:
Post a Comment