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,

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