Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hello,
In direct query mode on GCP views, we have observed that the generated SQL is not optimal in the sense that it selects all columns from intermediate tables even if we only want to display two columns in the visual.
Thank you very much for your assistance.
Best regards
Read about Value.NativeQuery
Thank you for your reply.
We have already tested and the behavior remains the same.
User | Count |
---|---|
85 | |
76 | |
72 | |
69 | |
56 |
User | Count |
---|---|
104 | |
99 | |
92 | |
78 | |
69 |