topic Re: ODBC Redis Data Load Error in Developer

ODBC Redis Data Load Error

Syamala — Thu, 20 Feb 2025 00:20:35 GMT

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

Re: ODBC Redis Data Load Error

Anonymous — Fri, 21 Feb 2025 01:42:24 GMT

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.