Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Error when viewing report

Couldn't retrieve the data for this visual. Please try again later.

Please try again later or contact support. If you contact support, please provide these details.

Hide details

  • Activity ID2784436a-7ba6-40ef-9d5f-0478f1379553
  • Request IDc309cb02-39ef-40f3-856c-4aa152f95842
  • Correlation ID99a2892c-193c-0491-bf87-c979a7415693
  • TimeWed Feb 28 2024 17:47:44 GMT+0800 (Singapore Standard Time)
  • Service version13.0.22729.77
  • Client version2402.3.18145-train
  • Cluster URIhttps://wabi-south-east-asia-b-primary-redirect.analysis.windows.net/

     

    The only way that anyone can view this reports, seem to be if they have admin access to workspace. 
    If i use a link, the views are broken and this error is on the visuals.

    There are 2 semantic models used, one main semantic model with RLS and another built on top, inheriting the RLS. There are a few new columns in the tables and the report only takes data from the 2nd semantic model (basically like a chain, rather than parallel). It's basically a report built on top of another report, using the same semantic model.

    When an intended user views the report, the visuals are broken, even when they are added to RLS and they are given access to the report and view access to the semantic model.

    I am at a loss here - this is an iritating problem on top of another issue i have. I cannot edit tables created in the original report, and the owner of the original report cannot edit mine. How do I:

    1. fix this issue (viewer seeing broken visuals)
    2. Have access to edit (either they edit my Pbix, or i edit theirs) as this should overall make it easier to trouble shoot


2 Replies

  • Anonymous , the Second semantic model is built on the first one, then it will use a direct query on the first model. which might break RLS. You should be able to re-build RLS in the second model in such a case

    • Anonymous's avatar
      Anonymous
      Not applicable

      when you say rebuild, do you mean recreate the tables/columns that reference the RLS? E.g can i just create a new table, create relationships between the new table and the old table and set the RLS on the report?

       

      My RLS limits the country filter for each dashboard, where each user can only see data from their own country.