Forum Discussion
Error adding table in directquery
I have a problem that I initially believed was a problem in SQl Azure but it was checked and everything is ok with the database.
I have a direct query application that all your data are from the same database and one day ago add some new tables from the same database and ok, but then I added another table and the following error is reported:
"Failed to save modifications to the server. Error returned: 'Allpatitions using Directquery mode with full dataview must query the same data source.'."
I found a topic here in the community about a similar error but from a different scenario, I made all possible attempts, including I can not add any more of that database's table in this application, which led me to believe that the error was in the database but how I told the database is Okay, what can I do to solve this problem?
5 Replies
Anonymous,
Open the Data source settings dialog and check Data sources in current file. Change source (usually case-sensitive) until only one appears.
Hello, v-chuncz-msft
I have done this, I have found a solution, but I have access to the advanced table editor and I copy the database connection string from the other tables that are already in the application and replace it in the load scrpts of the new tables, for now this is solving the problem, but I would like a final action to resolve the issue, and because this has only begun to come to fruition.
Anonymous,
Next time, you may get data by selecting Recent Sources.
