Hi Amit, did you extract the data source in Desktop before publishing it?
I thought I did. But now I am confused. Could you please let me know the ideal sequential steps that should be followed for a sample scenario like - Data source is a very big excel and now that has to be published ?
Could anybody please help?
1 of 1 people found this helpful
when connected to your excel file, extract the data.
When done, check that you are connected to the right server and site.
Right click on the data source or use menu Server than "Publish data source".
Choose the project in which you want to publish, be sure to include credentials (if you use a database, not for an excel file), check permissions and OK.
It can take a variable amount of time depending on your data size.
On the server, you should see your datasource with a "modified date" up to date.
Then connect your workbook to this datasource.
Hope to help