I'm baffled by this...I have multiple published dashboards coming from the same SQL server and database but this one i published today can't seem to connect.
This is the error i get when i try to open the dashboard:
When i test the connection, i get this. But when i test the connection to other dashboards that are using the same server, they connect successfully.
I've tried updating the driver, and no success. Any help will be greatly appreciated!
You may want to check the query in the data source. Something may have changed and so probably it's not working.