PowerBI visual access issue

[datan3rd]

Good afternoon,

I currently manage a Power BI performance dashboard operating in import mode, with data sourced from SharePoint. The ETL process is handled via dataflows, and the dataset is consumed directly by Power BI. No RLS has been configured.

The dashboard includes a section that displays data for a selected date, alongside another visual that presents daily historical data. Both visuals are connected to the same data model and dataset. While the user is able to view the report and interact with other visuals without issue, they are encountering an error specifically with the historical data visual (please refer to the screenshots below).

When I view the report as the affected user using the "View as" feature, the visual renders correctly. I’ve also confirmed that the user has direct access to the report. Given that access issues typically prevent the report from loading entirely (prompting a request for access), I suspect the issue lies elsewhere.

Has anyone encountered a similar issue or have any insights into what might be causing this behavior?

Thank you for your support.

[datan3rd]

You're right! thank you @lbendlin, found 1 culprit table that was coming from a foreign semantic model which the user did not have access to. Appreciate the quick response on this one. Cheers.

[lbendlin · Accepted solution]

You are using a composite data model, including a "foreign" semantic model. All your report users must have access to YOUR semantic model AND to THAT semantic model.

If you are using apps then all your users need to have registered BOTH apps.