Forum Discussion
Multiple datasets
I have successfully created a report by importing an excel file from my computer. After that, I have installed a gateway in a server to create a report getting data from a SQL Server. Now, I ...
This is what I see:
And, I can't find a way to remove the second datasource.
Anonymous
That second line is just showing that the enterprise gateway does not have access to your C drive so you can't use it to refresh your report.
The first line is the personal gateway that is selected as the one to use when refreshing the dataset "Updated_Dashboard v3" and looks like it is working. You should be able to refresh your dataset.
If you had 10 enterprise gateways at your organization they would all appear in that list but only your personal gateway would work (for this dataset) because it is the only one that has access to your C: drive.
Did you set up the personal gateway to use your windows credentials?
Yes