Data connector to open all Excel Workbooks in a folder

#1

Hello,


We have a bunch of Excel workbooks we want to use in a SharePoint folder, I tested out the SharePoint Excel Services data provider in Dundas BI. However, this only opens 1 Excel workbook, is there anyway it can just open all Excel workbooks to a defined folder I point it to?


Thanks in advance!

#2

Due to some limitations with the SharePoint API, this was not possible. I created a feature request to review this again, and you will be notified if that's made possible.


Meanwhile, you could try to use the Microsoft Excel data connector for this. It should work, but will likely require some tweaking on both the SharePoint and Dundas BI servers to allow the UNC path mapping.

#3

Thanks for the update!