I have about 6 different tables on our SQL database. I want to use these to create dashboards for our dept.
I've tried creating a "new" data source for the specific info I want per the tables. This works as long as the data is on its own worksheet. If I toggle to another worksheet that is connected to the same server/different tables (renamed for the data I need), then it "red" blocked out until I relink it. I essentially have about 6 tables that have specific info that I would like to have on the same worksheet. The "date" is the only common ground and when I try to join them the data is inaccurate. I'm in this "wack a mole" scenario.
Is there a "clean" way to connect to a database, pull in several tables and display the info on the same worksheet w/o having to "link/join/union"?
Can you share a workbook with sample data.
Check the relationships between the datasources that they are mapping correctly only on the date you want.
Cannot check the wrong results unless we look at how your data is structured
Might be easier to bring in the data using a custom sql if all your tables are in the same database