Solved: Connection to Parstream Database

Pavkanna · ‎03-23-2018

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?

v-yuezhe-msft · ‎03-24-2018

@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

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

View solution in original post

v-yuezhe-msft · ‎03-24-2018

@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

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

Pavkanna · ‎03-26-2018

@v-yuezhe-msft,

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.