Forum Discussion
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 Excel Spreadsheets (Archives) to. The Excel files are stored in the documents area of Teams. I have set the privacy level to "Public" based on the "solved" posts on other discussion topics but it has not resolved my error.
Can anyone shed some light on this for a possible resolution?
Data Source Permissions: Dataverse
Data Source Permissions: Excel
Data Source Permissions: Excel
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
4 Replies
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
BA_Pete Thank you for this as it did resolve that error. My power query was able to apply without error. Thank you.
Sounds 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
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.
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.
