I can't really believe this, I need to get data from a sharepoint list into
excel, ok, that is easy, create a data connection to the list, great. Now I have
created some graphs in said excel file that I need to publish to a dashboard
page. Is set up the trusted connection for the site, hit pusblish and bang, I
can't render the graphs because the data comes from SharePoint? For real?
Ok, fine, talk to the customer, great, the data no longer has to be live data, I
take out the Data Connection to SharePoint, publish the excel file as a service,
and guess what, I still can't render the graphs for the same reason.
Please anyone tell me this isn't true and I am doing something really wrong
here?