Forum Discussion

TheBishopEmpire's avatar
TheBishopEmpire
Frequent Visitor
1 year ago
Solved

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...
Data Protection
Need Help
Tips and Tricks
  • BA_Pete's avatar
    BA_Pete
    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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi TheBishopEmpire ,

Thank you for reaching out to us regarding the issue with appending data from your Excel spreadsheets to the Dataverse table.

 

As you said that you have already tried changing the privacy level to "Public," which aligns with solutions you've seen in other discussions, but the issue persists. So try the suggestion provided BA_Pete it might reslove your issue for more detail information kindly refer the following documention;

https://learn.microsoft.com/en-us/power-bi/enterprise/desktop-privacy-levels

 

For your reference, I am also including a similar thread that has already been resolved. Kindly refer to it.

https://community.fabric.microsoft.com/t5/Power-Query/Query-references-other-queries-or-steps-so-it-may-not-directly/td-p/2836287

 

I hope my suggestions give you good ideas, if you need any further assistance, feel free to reach out.

 

If this post helps, then please give us Kudos and consider Accept it as a solution to help the other members find it more quickly.

 

Thank you.