Couldn't load the data for this visual

[alderete-tomas]

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 mentioned). I have no problem with a measure that particularly combines data from API and Onelake, or with a measure that only reads from Onelake and is not combined with any other sources. Additionally, the report has an RLS applied.

There is no problem with that when testing RLS roles in Power BI Desktop, showing exactly what should be shown. My problems start when I publish the report to the PowerBI service and test it in the RLS, because those measures that use information from Onelake drop and fail. Attached is an image with the problem popup. When it's me looking, I don't have any problems.
More context:
The report is published in two workspaces, Te and Sa, both with premium capacity. A Python model running on Onelake in Workspace Sa is then used to return its result in both Te and Sa. The problem occurs in both workspaces.
How can I solve this?

[v-kaiyue-msft]

Hi @alderete-tomas ,

Thanks @GilbertQ  for sharing, here are some more suggestions that I hope will help you.

Please verify the refresh of the semantic model. Make sure the semantic model is successfully refreshed in the Power BI service. Data refresh issues may cause visual object loading issues. You can check the refresh history and status by navigating to the semantic model settings in Power BI Services. More information on refreshing can be found in the documentation: Data refresh in Power BI - Power BI | Microsoft Learn.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[GilbertQ]

Hi @alderete-tomas 

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.

[alderete-tomas]

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.