This has the answer and it worked for me.
https://www.uk365guy.com/resolved-the-report-cant-be-viewed-because-the-underlying-dataset-uses-row-level-securityrls-in-dynamics-365-power-bi-report/