I need to create a report using performance point service or BI. While creating the datasource it should be from a sharepoint list and same datasource i need to use to create the report. Any suggestions?

  • The suite of BI tools available through sharepoint provide multiple ways to expose and manipulate data. The best solution will depend on data complexity, data sources and UI functionality.
    – Russell
    Commented Jan 20, 2014 at 4:26
  • For example, you can create a simple PowerPivot spreadsheet to use (assuming PP is configured).
    – Russell
    Commented Jan 20, 2014 at 4:26

1 Answer 1


if you mean, you want to develop cube for BI datasource..

i think you need to do ETL first (using SQL Server Integration services) from SharePoint list to SQL server regular table, then you can develop cube with sql server as datasource..

IMHO, you might consider change you app datasource from sharepoint list to regular sql server table, for performance wise

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.