When you published did you embed credentials
Hi Khalid, I did.
I think I got the solution, i just change the data source Connection to Live..previously i was set it to incremental refresh.
So now whenever I refresh my workbook, it will just connect to this data source and extract the live data..is this the correct way?
When using a Live connection your credentials are already embedded.
Live connection will definitely give you more uptodate data as your data refreshes every 5 mins. but depending on the size of the datasource you may see a performance impact in using a live connection.
If you want to do an incremental refresh please share screen shots of the process you went through to set up incremental refresh and the steps you took too publish with credentials.
I can then advise where you may have gone wrong.