Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Row Level Security doesn't work after data refresh

Hello,

We have a report that uses RLS with multiple roles. After data is refreshed (manual or automatic), users cannot see any data. We then refresh data in Desktop and then publish to Service, and it works until the next auto refresh.

Anyone experienced this strange problem, and know the solution?

Regards, Vidyadutt

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    Thank you all for your comments. We have finally found what was going on.

    The data was refreshed, but we were getting empty values in the date column and that's why we couldn't see any data as it fails the relation with calendar dimension. The values coming from database were "datetime" and in Power BI, we changed the type to date in transformation. We removed this step and re-published the report to service, and bingo! I have no idea why the change in type would make all the values in the date column blank...

    Thanks again Mariusz and Icey for the pointers.

    Regards, Vidyadutt

6 Replies

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks Mariusz. I had seen this post, but it doesn't help. The problem we have is different.

      Regards, Vidyadutt

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi Anonymous ,

     

    Was the data source refreshed successfully? Can you see all data after refreshing?

     

     

    Best Regards,

    Icey

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Icey,

      That was a good tip. I checked the report and I can't see any data after refresh. I have found a few threads on this topic, and will check if any of those helps.

      Thanks for the tip.

      Regards,
      Vidyadutt

      • Icey's avatar
        Icey
        Community Support
        6 years ago

        Hi Anonymous ,

         

        What's the data source?

        Do you use a gateway for refreshing?

        Is there any error?

         

         

        Best Regards,

        Icey

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Thank you all for your comments. We have finally found what was going on.

    The data was refreshed, but we were getting empty values in the date column and that's why we couldn't see any data as it fails the relation with calendar dimension. The values coming from database were "datetime" and in Power BI, we changed the type to date in transformation. We removed this step and re-published the report to service, and bingo! I have no idea why the change in type would make all the values in the date column blank...

    Thanks again Mariusz and Icey for the pointers.

    Regards, Vidyadutt