shared data source

Question

hi

i am using shared data source in my all reports,

the problem is when i rename ,its not showing in data set ,its showing old data source that i have been deleted.

any idea

Answer 1

When you click on 'Refresh Fields' within your data set, does that update the available shared data sources?

Answer 2

Hi,

Thank you for sharing your problem with us.

Actually I'm not sure what you mean of RENAME.

If you are renaming your report, you should not have any problems.

Instead, if you are renaming the shared data source, it is obvious that your report cannot address to the new one as it doesn't exist anymore.

So, you need to reconfigure your report to use the new data source.

Cheers.

---

Please Mark as Answer or Vote As Helpful if a post solves your problem. MCP, MCTS, MCITP

Answer 3

Hi Tsql,

It shows the data source name in the dataset, rather than the shared data source name. Shared data source display in the drop-down list when you create a data source using shared data source. So if you recreate the data source using the new shared data source without rename it, it will showing old data source that you have been deleted.

If you have any questions, please feel free to ask.

Regards,
Charlie Liao

---

Charlie Liao
TechNet Community Support

Answer 4

hi,

exactly what i am looking for , the only problem is , in drop down data source, i am not getting my new data source name,

i need to click on new and then i need to create it again.

it should be by dafault  come under drop down

Answer 5

if i try to recreate it everytime its asking for username and password to run report

Answer 6

What type of credentials are you using to connect to the data source?

Double click on your data source and click on "Credentials"and select sufficient configuration:

If you are sure that the current user have sufficient access rights, select "Use current Windows user. Kerberos delegation might be required."

OR provide  a username and password that has the access rights.

Cheers

---

Please Mark as Answer or Vote As Helpful if a post solves your problem. MCP, MCTS, MCITP