Orchestration

Hi, I have two questions regarding Orchestration, schedule groups. (1) There is the option to make a schedule based on a SQL custom script. When I try to test this functionality out with the following statement: SELECT CAST('2025-06-10 01:00:00' AS DATETIME) It gives me the following pop-up: Does someone know why I don't get query result = '10-06-2025 01:00:00’? The SQL statement produces a valid datetime value in SMSS. (2) I need to schedule a job that runs four times per day for a project. I wanted to build this schedule with the custom SQL option and by using a calendar table in our database from the Prepare Instance. Is this possible? Thanks in advance!

Hello. We are working on adding PBI datasets to the Orchestration process. I have followed these instructions and up until no. 3 in the Power BI part, everything has been a success. However, I’m supposed to choose Orchestration > Packages, select New > Power Bi Refresh. But Power BI Refresh is not an option: Is there a particular reason for this? I have added Power BI Refresh to the workspace (as a member currently, does it have to be an admin? That is not specified in the instructions at least.) I’m on TimeXtender Data Governance version 24.3.0.87 Best regards.