received report, i dont have access to sql

[ilcaa72]

a colleague sent me a report that has 2 queries that come from SQL, when I try to "edit the queries" it ask me for permission to the SQL server (credentials).   i noticed he wrote some SQL code to get data.  Is this a direct query, should he select "import data" when quering SQL server so I can also access data thru "edit queries".

how can i access the data (2 small tables).  What can the user do on his end to make the data part of the model and not have to connect to SQL to access  the data on my end.  thanks

[v-danhe-msft]

Hi @ilcaa72,

could you please tell me if your problem has been solved? If it is, could you please mark the helpful replies as Answered?

Regards,

Daniel He

[v-danhe-msft · Accepted solution]

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-lo...

Regards,

Daniel He