Forum Discussion

BjoernSchaefer's avatar
BjoernSchaefer
Icon for Helper II rankHelper II
7 years ago

Data Refreshes very slow

Hello everybody and a happy new year,   i'm dealing with a very serious issue right now. Since the November '18 Update of PowerBI Desktop the Data refreshes take very long. Database is a IBM DB2 th...
Need Help
GTech01's avatar
GTech01
Frequent Visitor
7 years ago
We have the exact same problem with DB2, another ODBC which connect to an ecclectic SQL database named HFSQL. Our analyst tells me he have the exact same problem with the mashup but not the service.
  • BjoernSchaefer's avatar
    BjoernSchaefer
    Icon for Helper II rankHelper II
    7 years ago

    Hey there,

     

    thanks for the feedback. 

    Question(s):

    Are you using the native DB2-Connector in PowerBI? And wich Driver are you using? IBM or Microsoft? I'm using the Microsoft-Driver because i'm not able to get the IBM-Driver running. Wich always worked fine and really fast as well. 

     

    I quess this issue began with the release of DirectQuery for IBM DB2. Please treat this statement with caution, i'm still doing research on this but wasn't able to find any information.

     

    Regards

     

    Bjoern 

    • GTech01's avatar
      GTech01
      Frequent Visitor
      7 years ago
      We use native DB2 with Microsoft driver because we never found a way to make the IBM one working. The Microsoft one was very fast until december release.
      • BjoernSchaefer's avatar
        BjoernSchaefer
        Icon for Helper II rankHelper II
        7 years ago

        I think i've got something:

         

        Go to your DataSource Settings in PBI-Desktop and edit the Settings for the DB2. Change the Security Level from "None" to "Organizational" and restart PBI Desktop. 

         

        My Queries are loading much faster now.

         

        Let me know if it worked for you, too.

         

        Regards

         

        Björn