Forum Discussion

JohannesSpronk's avatar
JohannesSpronk
Frequent Visitor
3 years ago
Solved

DB2 IDAA

Please, does anybody know, whether and how you can enable the IBM DB2 Accelerator (IDAA) in the Advanced Editor of Power Query? I have the following: let Source = DB2.Database("Server", "Database",...
Need Help
  • JohannesSpronk's avatar
    JohannesSpronk
    3 years ago

    Our solution is to change the syntax in Power Query using Advanced Editor

    = DB2.Database("server", "database", [HierarchicalNavigation=true, Implementation="Microsoft", Query="SET CURRENT QUERY ACCELERATION=ENABLE; SELECT * FROM database.table FOR READ ONLY;"])

v-jingzhang's avatar
v-jingzhang
Community Support
3 years ago

Hi JohannesSpronk 

 

I don't have experience in IBM DB2 but I think it should have its own performance monitor tools like SQL Server Profiler for SQL Server Databases. You can create two queries in Power BI Desktop, one has the statement "SET CURRENT QUERY ACCELERATION=ELIGIBLE" while the other doesn't. Open the performance monitor tool and start monitor traces. Then click "Refresh" in Power BI Desktop to reimport data into Power BI. Every table will send a query to the database. After refresh finishes, you can stop the tracing and compare the query time of two queries. 

 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.

  • JohannesSpronk's avatar
    JohannesSpronk
    Frequent Visitor
    3 years ago

    Thank you for taking the time and replying with an advise!