Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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
Regards,
Daniel He
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
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
Regards,
Daniel He
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |