Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to connect Power BI with DB2 through DirectQuery

Hi,

 

I have an issue trying to connect a database IBM DB2 to my Power BI dashboard through IBM Driver. I checked on this forum all the topic related to this problem and I upgrade yet, the driver version to the last one.

 

The error is the following one:

 

 

I checked yet on the Power BI documentation that DB2 is a source allowed.

 

https://docs.microsoft.com/es-es/power-bi/connect-data/power-bi-data-sources

 

 

 

Thanks for the help.

 
Need Help
Tips and Tricks

2 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    Hi Anonymous 

    When connecting, which driver do you use? IBM or Microsoft?

    Is the IBM DB2 on the same server with your power bi desktop?

    This error indicates the server name and database name may not be correct and you may have limit acess to the server and database.

    Generally, the server name is host name: port name.

    please check if your account have acess to the data on IBM DB2 and check if your server open the port for it.

     

    Best Regards
    Maggie
    Community Support Team _ Maggie Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Hi Maggie,

       

      First of all, thanks for the help and the reply.

       

      I checked and I have the last version of the IBM driver since last Thursday.

       

      Second point, when I'm trying to do the same queries on the DB2 but using the "import" option I don't have any kind of problem. Really strange issue.

       

      Any other clue to solve this inconvenient ?