Forum Discussion
Extract values from tables dependent on table name
Hi all, Very new to Power Query and M, but been attempting to learn about this topic before resorting to posting. For example, what I am trying to achieve is I have a key table containing IDs it...
I don't think using #shared will work. This is due to query isolation, where none of the other queries will be avialable unless explicitly referenced when you load the data into the model. It works fine in preview, but will probably not when you do close and load.
If possible you should try and load all your tables into one query, and then reference that query in other queries to extract out the individual tables.
