I have a streaming dataset created in PowerBI service. In this dataset I have some records assigned to specific email address.
I'm using USERNAME() function to get current user and return pre-filtered result from dataset. Everything works perfect in PowerBI Desktop and PowerBI Service until I use dashboards.
I need dashboards to update the visuals immediately after new data is available because automatical refresh doesn't work for reports.
New dasbhoard looks good and returns information correctly. But as soon as new record(s) added to the streaming dataset USERNAME() function stop working returns nothing.
And in all related tiles (measures) I see just BLANK. I have a separate tile with current user funciton result, but it becomes empty.
Same time, I don't see any issues in the source report. It is working fine but requires manual data refresh. And dasboard is not working, refresh doesn't help, to see new actual results I have to readd tiles from the source report, but it is not an option of course.
My questions is how to fix the issue with USERNAME() function (same issue for USERPRINCIPALNAME() ) which doesn't work in dashboards based on streaming dataset when new rows added.