Forum Discussion
ODBC Error: Data source name not found and no default driver specified
Hi,
I have created a Power BI Report using a MongoDB data source. I've used the following ODBC connector to connect MongoDB to Power BI http://www.cdata.com/drivers/mongodb/odbc/
When I publish my report online and try to schedule refresh using my personal gateway, the following error occurs in the data source credentials: ODBC: ERROR [IM002] [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
I'm sure that the data source name and driver are specified correctly. Could there be any another reason for this error?
Hi jagrutijoshi,
You would also need to add all the CSV data sources under registered on-premises gateway, this way, you would be able to use on-premises gateway to refresh your dataset.
Thanks,
Lydia Zhang
12 Replies
Hi jagrutijoshi,
Do you install 32 bit or 64 bit ODBC connector ? And do you create system DSN for MongoDB following the guide in this blog?
Could you please install on-premises gateway and add the ODBC data source under the registered gateway, then check if you can set schedule refresh for your dataset?
Thanks,
Lydia ZhangI have installed 64-bit OBDC connector with proper DSN. On-premises gateway is disabled while we connect via ODBC driver.
Hi jagrutijoshi,
Have you added the ODBC data source under registered on-premises gateway?
Thanks,
Lydia Zhang
Hi,
There is a ready connector available for Tally which can import all data from Tally at pre-defined interval. You may connect on [email protected] for further details.
Regards,
Ravi
Hi,
There is a ready connector available for Tally which can import all data from Tally at pre-defined interval. You may connect on [email protected] for further details.
Regards,
Ravi
jagrutijoshi I've also created a Power BI Report using a MongoDB data source through ODBC connector and I'm trying to create a dynamic data source with parameters can you pls explain
