Forum Discussion
TheBishopEmpire
1 year agoFrequent Visitor
Query references other queries or steps, so it may not directly access a data source
I have reviewed many of the discussion posts related to this but couldn't find one that exactly fit my scenario. Here, I have a Dataverse table (Production) that i'm trying to append two different Ex...
- 1 year ago
Hi TheBishopEmpire ,
I'm not super-knowledgable in the Dataverse space I'm afraid, but in Power Query I would try switching off Privacy checking altogether (I'm assuming this is appropriate as you've already tried setting to Public).
Pete
nathancwatkins
Helper II
1 year agoSounds like you need to make a fourth query, and use that to append your tables; you can probably even just use "Append as new query".
--Nate