topic Re: Cannot access certain PowerQueries in the Data Export Manager in Community Forum

Cannot access certain PowerQueries in the Data Export Manager

ablume — Thu, 09 Feb 2023 14:10:54 GMT

I am the district administrator for PowerSchool in our district. Until this school year, I have never had issues with access, plugins, etc. However this year after installing a simple plugin that only has two power queries I cannot access the query for Students in the Data export manager. PowerSchool has been investigating this since August and suggested I reach out to the community. Any suggestions are welcomed.

Thank you,

Amy Blume

Re: Cannot access certain PowerQueries in the Data Export Manager

CindyM8 — Thu, 09 Feb 2023 17:31:31 GMT

Is this a third party plugin or one you created?

Re: Cannot access certain PowerQueries in the Data Export Manager

ablume — Wed, 15 Feb 2023 14:55:11 GMT

It was created by a PS Admin in our neighboring district where we share a career center. I also had this happened with SAVVAS API Plugin

Re: Cannot access certain PowerQueries in the Data Export Manager

Weg8k — Mon, 08 May 2023 19:37:13 GMT

Hi Amy!
Did you ever resolve this? I am having the same issue. I have installed a plugin with roughly 20 queries, and all but two are showing up in the data export manager!
Thanks,

Wade

Re: Cannot access certain PowerQueries in the Data Export Manager

ParitoshT — Mon, 22 May 2023 16:31:04 GMT

Hi @Weg8k,

Good Day! I recommend working with the technical contacts and the PowerSchool SIS administrators in your school district who would have worked on creating these queries and would be able to assist you further with this. They can also reach out to the PowerSchool SIS team through a support case on your behalf if required.

ParitoshT

Community Moderator

Re: Cannot access certain PowerQueries in the Data Export Manager

AdamL9 — Wed, 04 Sep 2024 13:49:40 GMT

I was having the same issue with a plugin I'm building. It appears that a PowerQuery can either be used as a DAT or in Data Export Manager. Removing the DAT capability from my queries addressed the issue. Of course, if you want both, you're in a bit of a bind.

Additionally, each query must have ~~POST~~ GET permissions on at least one page accessible to the user in question.

Hope this helps!

Re: Cannot access certain PowerQueries in the Data Export Manager

keles — Tue, 22 Apr 2025 13:23:57 GMT

Hi,

We need to use ADA ( {{dat.(*evaluate round(100-^(*DABS;^(entrydate);^(f.currentdate))/ ~^(aggmemdaysytd)*100,2))}} ) in an export template?

How can I do it ? Is there any documentation ? Thank you very much in advance!