Forum Discussion
Helper IPower Apps visual in Power BI not working
Hi guys,
again, thank you all for your help. Finally, it showed up that the problem was somewhere else. That's why I cannot tell which of your answer solved my problem, as the problem was different then I described.
The problem was in a language version of Power Apps. I use the czech version (cannot force browser to be in english for some reason) but my coleague user english version. And Power Apps has different approach to name of aggregation. The column from Power BI was aggregated and czech naming was used for it instead of "Sum of..." And that didn't work for my coleague which I falsely evaluated as problem of connection (as she was not able to see any connected data). No, it was a problem of bad naming of a column that was used to filter Sharepoint table.
Feel bad about it. Sorry that I misled you.
Vašek
Super UserHi Vasek00005
The issue you're experiencing with the Power Apps visual in Power BI, where it displays SharePoint data for you but not for your colleague—even though they have identical SharePoint permissions—most likely stems from how Power Apps handles data source authentication per user, especially within embedded contexts like Power BI. While your colleague can access and edit the SharePoint list directly, Power Apps still requires that each user consent to using the SharePoint connection within the app’s context. This is a one-time authentication step that Power Apps enforces for security, even if the app is embedded in Power BI.
What’s happening behind the scenes is that the Power Apps visual runs in the context of the logged-in Power BI user, and if that user hasn't previously granted consent for Power Apps to access SharePoint on their behalf, the app fails to load data—even though static content within the app appears. Unfortunately, this is a known limitation, and while Microsoft documentation is sparse on this specific embedded scenario, the suggested workaround is often to have the user open the standalone Power App once (via a shared link), which triggers the authentication and consent process for SharePoint. After that, the embedded app in Power BI should work seamlessly.
For broader deployment to non-technical users like management, the best practice is to pre-authenticate the app using service principals, or redesign the experience to avoid embedded visuals where user consent is a bottleneck. Currently, though, there is no fully seamless way to skip this per-user authorization step unless your organization leverages Azure AD Conditional Access and consent policies to pre-consent access for all users—something your IT admin can configure at the tenant level.