Report visuals blank for some people. With specific table errors - The key didn't match any rows

[nmckeown1]

On a report shared with me, I can't view the visuals on power BI report using SQL database. I get the error:

"The key didn't match any rows in the table.. The exception was raised by the IDbCommand interface" - this is on every page for and is the same error for all tables and keys in the report.

I have been granted full permissions, and others can view it but I still cannot. It usually says an access issue if this was the case, but I thought the error means the power query might have changed - however why would everybody else viewing not have this error?

[Kedar_Pande]

• Verify your SQL database credentials in File > Options and settings > Data source settings.
• Confirm if RLS is applied and if it restricts your access to data.
• Download the report and try opening it in Power BI Desktop for more detailed error messages.
• Create a new report with the same SQL database to check if the issue persists.

If this helped, a Kudos or a Solution mark would be awesome! 🎉
Cheers,
Kedar Pande
Connect on LinkedIn