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 Jan 20 '14 at 4:26
  • For example, you can create a simple PowerPivot spreadsheet to use (assuming PP is configured). – Russell Jan 20 '14 at 4:26

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, privacy policy and cookie policy

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