received report, i dont have access to sql

Hi ilcaa72,

For the first issue, you could not access the data in query editor although your colleague switched Direct Query mode to Import mode without valid data source credential. The query editor cannot read the data stored in the data model. Even if it could, the data in the data model represents the output of the very last step and the query editor wants to be able to show partial output for intermediate steps. That data is never loaded into the data model.

For the second issue, your colleague could create a login for you in SSMS to make sure you could access the data in query editor

Reference: https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-login?view=sql-server-2017#SSMSProcedure

Regards,

Daniel He