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.
When powerbi loads SQL statements into powerbi desktop, does it import the results from the data source and then import them into pbi desktop, or does it load the data from the data source into the memory of powerbi and then execute the SQL query results?
load SQL statements results from powerbi desktop is slower than load SQL view with same query conditons from database?
It really dependes on the Query and if "Query folding is happening" . I will leave you below an article that explain what query folding is and how it works. I hope that help 🙂
https://learn.microsoft.com/en-us/power-query/power-query-folding
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 |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |