May 28, 2021
Not sure I phrased this right in the title, but here goes.
I have a simple 3 row file 7 columns wide table that has 'sparse' data. This data will be filled in over time as a project moves forward but in the beginning there is only some basic setup data, 4 - 5 cells filled in. I have no problem running this through PQ and linking to a workbook for configurating my dashboard. Here is the question/issue.
When I update the table with additional information and refresh the query it generates a new data set, it does not use the original, i.e. 'Raw Data 2' rather than just updating the original 'Raw Data' data set. Now that causes issues with the downstream dashboard setup in that there is no way to simply execute a 'Refresh Data' command and have the dashboard data update. This is because the newer data is in a different 'unlinked' data set in the query.
Is there a way around this to where only the original data set in the query is updated? That way, I presume, the linked data set would then update on refresh in the dashboard.
July 16, 2010
I'm a bit confused by your description. Each query links to a single data source and then puts the final query result either into another table (I'll call this the output table), or your data model depending on what you originally choose in the Close & Load dialog box.
If you want to add new data to the original query then you must enter it in the original source data table, and then refresh the query. When a query refreshes, it replaces all the data in the output table with the new data found by running/refreshing the query. It does not preserve the original query and only append new data to the bottom. Therefore, if you make changes to the query output table they will be lost upon refresh.
I hope I've understood the issue and clarified things.