Forum Discussion

PBIFanHook7's avatar
PBIFanHook7
Helper III
11 months ago
Solved

Power BI Desktop sql native queries vs Power Query Editor native queries performance differences

I have read where the performance difference between using native SQL queries within Power BI Desktop's "Get Data" options verses using Power Query Editor (Get Data) and applying transformations in P...
Need Help
  • Ritaf1983's avatar
    Ritaf1983
    11 months ago

    Hi PBIFanHook7 

    It is generally best practice to push transformations as close to the source as possible. If you cannot create a proper view in Oracle, then using a native SQL query in Power BI is fine. Performance considerations will still apply in DirectQuery mode, since it is always slower compared to Import mode. The SQL query you wrote will execute on the Oracle database itself, and the results will be returned to Power BI.

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly

v-tejrama's avatar
v-tejrama
Community Support
11 months ago

Hi  PBIFanHook7 ,

 

Thank you Ritaf1983  for the response provided!

Has your issue been resolved? If the response provided by the community member addressed your query, could you please confirm? It helps us ensure that the solutions provided are effective and beneficial for everyone.

Thank you for your understanding!