I would like to build SharePoint 2013 based reporting portal with Power View as visualization tool.
I have 2 scenarios as data source. A) SQL Server Data Mart. B) Flat Files
I have 300-800 millions fact rows.
I would like to refresh data atleast once in hour.
How tabular and Power Pivot is different concerning data source?
How tabular and Power Pivot is different concerning data refresh? (real-time requirements)
How tabular and Power Pivot is different concerning performance?
According to your description, you are creating a PowerView report on SharePoint 2013, now what you want is compare which connection is better, Excel PowerPivot workbook or SQL Server Analysis Service tabular model.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.