Solved: ODBC Error: Data source name not found and no defa... - Page 2

jagrutijoshi · ‎04-06-2017

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?

v-yuezhe-msft · ‎04-17-2017

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

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

ODBC Error: Data source name not found and no default driver specified

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024