ODBC Redis Data Load Error

[Syamala]

I am having issue while loading data into PowerBI
I am able to connect REDIS DB using ODBC driver, but when I select Redis document of JSON type and try to load data into PowerBI getting below error.

DataSource.Error: ODBC: ERROR [42000] syntax error, unexpected NATURAL
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=Redis Dev
OdbcErrors=[Table]

Can someone help with this?

Thanks

S

[Anonymous]

Hi @Syamala ,

I think you can try Redis SQL ODBC connector to get data from REDIS DB in Power BI.

You can follow the steps in below offical blog.
For reference: How to use Redis as a Data Source for Power BI with Redis SQL ODBC | Microsoft Community Hub

Best Regards,
Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.