cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jagrutijoshi
Frequent Visitor

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? 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Moderator v-yuezhe-msft
Moderator

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

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

11 REPLIES 11
Moderator v-yuezhe-msft
Moderator

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

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 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.
jagrutijoshi
Frequent Visitor

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

I have installed 64-bit OBDC connector with proper DSN. On-premises gateway is disabled while we connect via ODBC driver. 

Moderator v-yuezhe-msft
Moderator

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

Hi @jagrutijoshi,

Have you added the ODBC data source under registered on-premises gateway?

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.
jagrutijoshi
Frequent Visitor

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

When we load the data in Power BI online via ODBC connector, the on-premises gateway appears disabled. It seems like that functionality is disabled. 

Moderator v-yuezhe-msft
Moderator

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

Hi @jagrutijoshi,

Could you please post a screenshot about your sceanrio? You can check this similar thread about how to add ODBC data source under gateway.

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.
jagrutijoshi
Frequent Visitor

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

pb.PNGThis is what it is showing even though the data source have been connected properly with the gateway.Please refer below for the same:pb2.PNG

 

 

 

 

 

 

 

Moderator v-yuezhe-msft
Moderator

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

Hi @jagrutijoshi,

Have you included other data source except the ODBC data source in your dataset? Could you please post a screenshot about data sources in your PBIX file?  You can go to File -> Options and settings ->Data source settings to check data sources for Power BI Desktop.

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.
jagrutijoshi
Frequent Visitor

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

We have 3 csv files as well.

Moderator v-yuezhe-msft
Moderator

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

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

Helpful resources

Announcements
New Ranks Launched March 24th!

New Ranks Launched March 24th!

The time has come: We are finally able to share more details on the brand-new ranks coming to the Power BI Community!

‘Better Together’ Contest Finalists Announced!

‘Better Together’ Contest Finalists Announced!

Congrats to the finalists of our ‘Better Together’-themed T-shirt design contest! Click for the top entries.

Arun 'Triple A' Event Video, Q&A, and Slides

Arun 'Triple A' Event Video, Q&A, and Slides

Missed the Arun 'Triple A' event or want to revisit it? We've got you covered! Check out the video, Q&A, and slides now.

Join THE global Microsoft Power Platform event series.

Join THE global Power Platform event series.

Attend for two days of expert-led learning and innovation on topics like AI and Analytics, powered by Dynamic Communities.

Community Summit North America

Community Summit North America

Innovate, Collaborate, Grow. The top training and networking event across the globe for Microsoft Business Applications

Top Solution Authors
Top Kudoed Authors