Forum Discussion
Power Query and permissions in Office 365 Enterprise
Hello Excel Community, Me and colleagues have Office 365 E3 licences. I have an Excel master file saved in a SharePoint site. This file contains many rows of data, and I want to grant each collea...
Excel is not the tool which secures data, it only protects data from the negligence. Protections could be relatively easy removed, power query is not protected at all. Thus all depends on end user qualification which may not be very high to access the data.
RLS within Power BI is much more reliable. End user on Excel could receive data as PivotTable connected to Power BI dataset; or you may create within dataset measure which returns desired table as CSV text, connect it from Excel with cube formulae and parse with dynamic arrays. However, didn't test above scenario exactly with RLS.