Forum Discussion
Couldn't load the data for this visual
I created a report that combines Excel data into Sharepoint, Onelake Data Hub and API. Within the report, there are several measures that sometimes combine more than one type of source (the ones I me...
Could you please give more context in how I'm using pattern to run the data on the onelake? It would appear that when you are using Row Level security that it is using the persons details to run the query and that is why you'll get in the error for other people.
Yeah, sure!
RLS is applied in a table called DIM_SITES, where you can find ID_Site, Site_Name and Country. This is connected to Onelake by a relationship bewteen ID_SITE, therefore, the RLS contains profiles such as Country = "Country" or ID_SITE = "A_SITEID". There is nothing related to the person or visor of the report, it's just that they are assigned to those RLS which are shown correctly in Power BI Desktop.