1

I'm having trouble with data PowerPivot data refresh...

I have made 2 workbooks:

1 - Put some random data, to use this workbook as a data source. I put it on SharePoint server PowerPivot gallery... (http://spserver/data/model.xls)

2 - I made another workbook, select data source (http://spserver/data/model.xls) put some dynamic table... and work with data.

When the second workbook is on my desktop... I can work with it without a problem.

But, when I put the workbook on SharePoint (http://spserver/reports/report01.xls) and access this via Excel Web App... I can't filter data, can't update anything... so... not working.

The error:

Access was denied by the external data source. The following connections failed to refresh: mycustom datasource

Where can I found error log? Windows Log Event ?! How can I troubleshoot this type of error?

Improve this question
4
  • Which sharepoint server version are you using and which powerpivot version? Commented Apr 4, 2018 at 20:02
  • I was wondering how you expect the security to work, what authentication. Have you considered using a connection library? Commented Apr 5, 2018 at 23:12
  • You had me thinking that I hadn't used a data connection library for a while, so I did some checking. I was also curious about the Web App. Commented Apr 5, 2018 at 23:30
  • Before I was interrupted.. Check the SharePoint Online Help, the Web App will not refresh from another workbook model. Commented Apr 5, 2018 at 23:39

1 Answer 1

Reset to default
0

You can troubleshoot these errors by looking at the SP logs of your farm

normally : C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\ 14 , or 15, or 16 \logs\

you can then review this logs in real time using ULSviewer.

but first you have to enable logging in your sharepoint farm:

central Admin> monitoring > Diagnostic logging

Improve this answer

Your Answer

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

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.