Forum Discussion

jagrutijoshi's avatar
jagrutijoshi
Frequent Visitor
9 years ago
Solved

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 publi...
Need Help
  • Anonymous's avatar
    Anonymous
    9 years ago

    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

Anonymous's avatar
Anonymous
Not applicable
9 years ago

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

jagrutijoshi's avatar
jagrutijoshi
Frequent Visitor
9 years ago

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

 

 

 

 

 

 

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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

    • jagrutijoshi's avatar
      jagrutijoshi
      Frequent Visitor
      9 years ago

      We have 3 csv files as well.

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        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