PowerPivot models as a datasource for Report Builder and PPS

  • Article

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=https://<servername>/PowerPivot Gallery/<Powerpivot_filename>.xlsx