Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
I’m trying to build a report based on data stored on local MongoDB database, with the ODBC connector.
But I’ve got the following error :
DataSource.Error: ODBC: ERROR [HY000] [MySQL][ODBC 1.0(a) Driver][mysqld-5.7.12 mongosqld v2.5.0]Unknown database ''
Details:
DataSourceKind=Odbc
DataSourcePath=dsn=MongoLocal64bits
OdbcErrors=Table
Notice that it works fine on Qlik based on the same ODBC source (64 bits).
Steps to reproduce on PowerBI (Version: 2.60.5169.4101 64-bit July 2018) :
Here’s the complete query to get the error :
let
Source = Odbc.DataSource("dsn=MongoLocal64bits", [HierarchicalNavigation=true]),
demo_Database = Source{[Name="demo",Kind="Database"]}[Data],
animals_Table = demo_Database{[Name="animals",Kind="Table"]}[Data]
in
animals_Table
Did someone already have this error and fixed it ?
Regards.
JN.
Solved! Go to Solution.
Hi JN.,
We found the cause. We should add the Database explicitly. Please check it out.
Best Regards,
Dale
Here is the solution... Thanks to all the other posts. If you want to see it in action, here is the answer!!
Your solution is not acceptable because the link to the image is available, please post it in to the solution directly!
Hi Dale,
Thanks for your great help !
I think that there's a bug somewhere because the database was actually selected in the query :
demo_Database = Source{[Name="demo",Kind="Database"]}[Data]
But your workaround is fine and it works for me.
Best regards.
JN.
Hi JN,
I tested with almost the same settings as yours. It seems fine. Can you share your "drdl" file? But I don't think that will be a problem. BTW, my MongoDB is the latest community version hosted in Ubuntu 16.04.
Can you share a snapshot of the ODBC settings, please?
Best Regards,
Dale
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
85 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |