PowerPivot models as a datasource for Report Builder and PPS


PowerPivot models, aka xlsx files can be used as datasources for report builder reports, also performance point analytics. The connection string is of type Analysis Services

Data Source=http://<servername>/PowerPivot Gallery/<Powerpivot_filename>.xlsx

Skip to main content