Direct query - Viewer access

Hi Blue_BIGuy ,

Based on your description, the problem seems to be caused by the Row-level security  set up in your report.

If you publish your Power BI Desktop report to a new workspace experience in the Power BI service, the RLS roles are applied to members who are assigned to the Viewer role in the workspace. Even if Viewers are given Build permissions to the dataset, RLS still applies. Workspace members assigned Admin, Member, or Contributor have edit permission for the dataset and, therefore, RLS doesn’t apply to them. 

You will need to contact the workspace admin to reassign the user role.
Or contact the report creator to remove the RLS settings (this is not a very wise choice considering the protection of the data. But if the data can be presented to these users, you may consider this suggestion)

Hope it helps,

Community Support Team _ Caitlyn Yan

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