Forum Discussion
ODBC Redis Data Load Error
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
1 Reply
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 HubBest Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
