Forum Discussion

Pavkanna's avatar
Pavkanna
Regular Visitor
8 years ago
Solved

Connection to Parstream Database

Has anyone tried connecting to Parstream Database? I have used ODBC drivers in past to connect Parstream to other BI tools. Any suggestions on how I can implement that here?

  • Anonymous's avatar
    Anonymous
    8 years ago

    Pavkanna,

    You can create a ODBC connection for Parstream database, then connect to the ODBC data source using ODBC connector in Power BI Desktop.

    Regards,
    Lydia

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Pavkanna,

    You can create a ODBC connection for Parstream database, then connect to the ODBC data source using ODBC connector in Power BI Desktop.

    Regards,
    Lydia

    • Pavkanna's avatar
      Pavkanna
      Regular Visitor
      8 years ago

      Anonymous,

       

      So I did the same. I created a ODBC conection but am running into this error. There is no log in Trace folder for me to see what is the problem exactly. I have created a User DSN as Power BI desptop is not recognising a System DSN. I also am able to connect through a connectin string but not able access the data.

       

      DataSource.Error: ODBC: ERROR [HY000] Error while executing the query
      Details:
          DataSourceKind=Odbc
          DataSourcePath=dsn=ParstreamUser
          OdbcErrors=Table

       

      Any help is appreciated.