Skip to main content

Data Factory

Needs Votes

Make Power Query Online able to read encrypted XLSX files due to Sensitivity labels

Vote (28) Share
Renato Lira's profile image

Renato Lira on 13 Aug 2024 11:54:33

Several businesses have the need to exchange data via XLSX files. Due to company policies, the correct classification of sensitivity label for some files adds encryption to them.


Power Query versions from Power BI Desktop or published Semantic Models(aka datasets) in Power BI Service/Fabric are already compatible with reading data from those encrypted files.


Power Query online (attached to Dataflows Gen1 and Gen2) is not compatible to read encrypted files due sensitivity label policies


Since best practices suggest that you should move your transformations as upstream as possible (which for the business user means using Dataflows), this is a much-needed feature.