Users can't see content for Power BI app report in (modern) SharePoint
Submitted byAnonymouson09-25-201809:28 PM
I was training a user on how to use PowerBI today. We have a a report, which is published to the server and is part of a verified app, so users without a PowerBI pro license can view it. The user had Row Level Security (RLS) the same as other users and the user profile was the same as other users also.
When we started the training it was observed that the date format (dd/MM/yyyy) had changed to (MM/dd/yyyyy). This appeared to be related to the user using Chrome, so the user moved to MS Explorer and the date issue resolved. However it was noted that on all of the tabs it was as though something was filtering the data so that not all of the data could be seen. I had one other user last week complain of a similar issue, where they could only see one of four data sets suggesting RLS limiting access, even though they were granted full access under RLS.
Today's user also faced similar data issues. We tried updating to remove all filters and used the PowerBI (browser) reset to default, to remove any issues arising from operator set filters, however this had no effect. In one instance, one of the tabs had no data at all when it should have been quite full. I have looked at computer settings and user profile settings, but to no avail. The data refresh date was exactly the same as the data I was looking at, but in one instance (for example) where I had a value of 89, they had a value of 68 for the "same" settings. Evidently something was happening as some of the filter controls had disappeared, suggesting that a filter was applied to it, but would not reset, nor could the filter be found.
The report is comparatively large (by our standards) with 21 tabs, but normally runs well.
The report is refeshed daily and published, but cannot be refreshed server side as the databases used by it currently do not support the API, or gateway technologies.