In Power BI Desktop >> Transformations, we have the ability to DISABLE options per query: "Enable Load" and "Include in report refresh". It would be great if Dataflow Gen2 had the same or similar opt...
I have Dataflows Gen2 that I created from Power Query Template files. Some of the queries reference Excel files stored elsewhere. Fabric does not have access to said Excel files, so the VALIDATION of this Dataflow Gen2 WILL FAIL.
I would like the VALIDATION process to bypass or skip the Queries that reference Excel files (or other objects to which I do not have access or line of sight to yet). Keep in mind that NONE of the queries have Destinations configured. I ONLY want to make sure that the queries in which I am interested PASS validation.
Again: Consider the design experience of Pipelines. I can have a Task on the canvas that is NOT configured and I cannot SAVE the Pipeline UNTIL one of two things: A) the configuration errors are corrected, or B) the task is set to "Deactivated". This lets me continue working, knowing I will go back and 'fix' the errors.
When I SAVE the Dataflow, any Query that is 'DISABLED' or 'DEACTIVATED' should get excluded from the VALIDATION PROCESS.
When I RUN the Dataflow, any Query that is 'DISABLED' or 'DEACTIVATED' should get excluded from running.
