I'm trying to combine multiple large files and summarize data in Power BI.
I'm trying to move away from EXCEL because I want to use row level security and grant access to specific users. Also, excel files can become large when sharing with others.
What I'm unable to find anywhere is a drill down function in the pivot table in Power BI.
I'm unable to find this anywhere in the menus and looking at their forums people are unsure, December 2015 they were "working on it," but there have been no updates from that moderator since.