integration with sharepoint 2013

Hi Anonymous,

Is there something specific that you are interested in ?

Sharepoint is a mechanism that helps streamline how your company can centralise data and reporting, which can eventually be fed into Power BI. I can only give you a few ideas based on what we (my company) has done:

Note*

If you want full capability of Microsoft's BI suite, then you will need Sharepoint Enterprise 2013 installed on your local infrastructure OR Azure on a VM.

Sharepoint is used as our central reporting/BI portal that provides the following capability:

1. Repository for Data files (mainly CSV & Excel) used for reporting purposes. Each department is responsible for maintaining their pages.

2. Access to online PowerView, PowerMap etc reports for each department

3. Uploading of PowerBI source files to OneDrive, to allow automatic refreshing of PowerBI Dashboards (I know OneDrive is a separate product, however we integrate it with Sharepoint to avoid confusing staff).

4. SSRS reports

5. SSAS cubes (Note* We haven't created any cubes as yet. However, this functionality is just around the corner for PowerBI)

6. We allow select users to open raw data files within PowerBI. These are essentially just links back to the CSV/XLS file in Sharepoint that automatically open in Excel.

I don't think this answers your question, but if you are more specific, I am sure we can help you out further.

Cheers,

Dan