Forum Discussion

Soc3's avatar
Soc3
Helper I
4 years ago

Microsoft Query equivalent in Power BI

I inherited a spreadsheet that's connected to DB2 data via Microsoft Query. I don't see Microsoft Query as an option in Power BI for a data source, does anyone know why this is? I know IBM DB2 is a data source in Power BI, but I don't know the server name to get connected using that method. Does anyone know how to get the server name or an equivalent of Microsoft Query in PBI?

Need Help

1 Reply

  • Watsky's avatar
    Watsky
    Solution Sage
    4 years ago

    Hey Soc3,

    When you load the data source from MS Query are you clicking on Databases or OLAP Cubes? If you're clicking Databases it's probably using an ODBC driver. In your start menu search for ODBC:

    Check under drivers and see if you see the IBM DB2 drivers in there. 

    If you see it there then check your User DSN / System DSN for the database you're connecting to. If you find it there then you can use the ODBC connector in Power BI to connect to the db.