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

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.