We would like to use Dataflow Gen2 to ingest files that have been encrypted by Microsoft Purview Information Protection controls, i.e. sensitivity labels.
Currently, Power Query Online (Dataflow) and Power Query in Excel are unable to access encrypted Excel files. Since Excel files labeled with sensitivity types other than "Public" or "Non-Business" are encrypted, they aren't accessible through Power Query Online (Dataflow).
This appears to be a current product limitation related to the underlying Power Query experience used by Dataflow Gen2. Encrypted files protected through Microsoft Purview Information Protection are not currently supported as source files for Dataflow ingestion scenarios. As described by an MS engineer, "Where encrypted workbooks could not be processed by Dataflows, removing the encryption resolved the issue". If possible, we would like this to be mechanism to be developed.
