memory issues, errors when creating hierarchy using PATH & PATHITEM Functions

[Anonymous]

Hi everyone,

I have ran into an issue where Power BI is giving me multiple error messages, and I have now hit a brick wall here. I have tried the following with Power BI July release, and I am currently working with 2.38.4491.282 64-bit (August 2016).

Scenario
I want to apply security on my data set to make sure managers can only view their department. My data set consists of about 1100 rows, that I filtered to narrow down to around 8 rows, for testing reasons. In the data set, Employee Name and Supervisor Name. I have used these two columns to create a hierarchy using PATH() and PATHITEM() DAX functions. I created about 5 columns;
- 1 for storing the result of PATH(). This column stores the entire hierarchy, and with the 8 rows, it has about 4 levels
- Rest of the columns are for 4 levels of hierarchy
I have been able to create and test roles, and all works as expected.

The Problem
Problem begins once I start working with the entire data set of about 1100 rows. From the error message below, it looks like there's a code level bug, something to do with some pointer or something else. This is now appearing to be a crticial issue for my implementation of the business.

PBI Desktop error

Computer specs

I have flicked it to Power BI support but I am yet to receive a response that could help.

Thanks

Kaz