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,

 

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

jagrutijoshi's avatar
jagrutijoshi
Frequent Visitor
9 years ago

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

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi jagrutijoshi,

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

    Thanks,
    Lydia Zhang

    • jagrutijoshi's avatar
      jagrutijoshi
      Frequent Visitor
      9 years ago

      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. 

      • 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