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 ...
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

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