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
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

    • GTech01's avatar
      GTech01
      Frequent Visitor
      7 years ago
      It doesn't work for us.
      • BjoernSchaefer's avatar
        BjoernSchaefer
        Icon for Helper II rankHelper II
        7 years ago

        Same with me. It worked for one day and MS closed my ticket. I hope that the next update will fix this. Otherwise i really don't know what to do.

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

    Same with me. I already opened a Support-Ticket. Now we play the waiting game. As soon as i get a reply from MS i will post it right here. Maybe it'll help you too.

     

    Greetings from Germany to where ever you may roam.

    • GTech01's avatar
      GTech01
      Frequent Visitor
      7 years ago
      Thanks From Canada BTW