Doesn't Power Query pick up Union Queries in Access?

[Vaslo]

I created a simple Union Query in Access, but when I refresh the "Source" it doesn't show up (and half the time all the queries disappear for no reason but come back after a dozen of so refreshes). When I try to manually type in the name of the query in the Navigation step, I get the "Key didn't match any rows in the table. Details: Key = Record Table = Table"

Is this another limitation of Power Query? Thanks!

 

[theBardd]

I get exactly the same, so I guess that it is a limitation.

 

[anvg]

Hi
I could not to view any an union query from my test Access database. Alright. I made a first trick. It was

Select id,fname,fvalue From
(Select id,fname,fvalue from table1
UNION Select id,fname,fvalue from table2) aunion;

But I got your error message "Key didn't match any rows in the table. Details: Key = Record Table = Table". Indeed, both table (table1 and table2) have id column as primary key. But that trick union query combines them together and it does not remove a definition of primary key from id column of the query.
Alright. Make another trick.

SELECT id1*1 AS id, fname, fvalue
FROM (Select id as id1,fname,fvalue from table1
UNION Select id as id1,fname,fvalue from table2)  AS aunion;

Make a id1 alias name for the id column of tables and in a select statement create a calculating column 1*id1 (let id column type is numeric).
It works fine.
Regards,