SharePoint PowerView connection using an Excel document as data source RRS feed

  • Question

  • Not even sure this is possible but here goes. We are trying to make a, “Microsoft BI Semantic Model for Power View” connections to XLSXs files as a data source. The XLSXs files are stored in SharePoint. It works on some spreadsheets and fails on others. The spreadsheet that the connection fails on have connections of their own to a backend SQL server. We setup an Application ID in the secure store called PP Testing, and called PP Testing in the connections of the spreadsheet. This is an example:

    Now when we try and setup a report data source to that spreadsheet, it fails with a connection cannot be made. Ensure the server is running.

    Thanks in advance

    Wednesday, May 15, 2013 6:16 PM