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.– RussellJan 20, 2014 at 4:26
-
For example, you can create a simple PowerPivot spreadsheet to use (assuming PP is configured).– RussellJan 20, 2014 at 4:26
Add a comment
|
1 Answer
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