Hi guys, I hope you can give me some insights of what I am trying to do.
Basically, I have a worksheet (WBook A) that references its data - using Power Query - from another workbook (WBook B)that I am downloading from the internet - a CSV File. What I am trying to do is to get the desired data from WBook B to show as a report in WBook A. The problem though is that, whenever I try to update the information in WBook B, I'm always getting errors stating that a connection and/or the Data Model is broken.
Am I doing something that I am not supposed to be doing here? Or do I need to change my approach on updating the data?
Any help or insights would be very much appreciated.
Thanks.
What I have tried:
What I am doing, and I don't want to keep on doing is that whenever I have newly downloaded CSV file, I copy and replace the old one and after that I need to recreate the table query in WBook A in order for it to be updated. I have like 3 thousand rows from WBook B that I am referencing from based on a row, named SKU using VLOOKUP and IF statements and copying the information from the new CSV file to the old one will be a tedious one since I have a lot of cells with information.