Copilot connection to Powerbi

Hi Everyone.

Currently trying to make a connection to our PowerBi platform through Copilot Studios. So far i keep getting a connection failure. I have tried to adjust our security settings in Active Directory. I have tried adjusting the permission on the workspace and access to the datasheet. When i use the Json query to extract on the columns in the giving table i just get a connection error. even though the connection seems valid.

Any suggestions on how to proceed?