PowerBI sheet location/key varies from user to user
Hi all, I'm hoping someone here might be able to address the following issue i've just encountered.
I've created a dashboard in PowerBI to visualize some activities in a sheet. It all works fine on my machine but when I share the PBIX file with another user, the data from SmartSheet returns a blank table. I've managed to conclude that this is due to the sheet being buried in a folder on the other user's account as opposed to appearing in the 'root' on my account.
I've confirmed this on my account by putting sheets in folders (and sub folders) and the result is the same.
So i've got 2 questions:
- Is this issue 'known' by Smartsheets? as its quite a limitation when sharing sheets within an organisation
- Does anyone have a suggested work around/fix for this issue? (apart from centralizing reporting and not sharing PBIX files...)
I have had some success using Table.Contains in the query to try and locate a specific key but this only works 1 layer down and would be of no use if there are folders within folders...
Hope this is enough info to explain the issue,