How to connect Azure Analysis Services to MongoDB for a tabular data model?

Jon 101 Reputation points

I am using Visual Studio 19 with the Microsoft.DataTools.AnalysisServices add-in which as far as I know is the correct (only?) way to build a tabular data model and requires the On-Premise Data Gateway. I need to connect to our MongoDB datasource and have created 32 and 64 bit ODBC DSNs. When I select my data source in VS Tabular Model project, I am only presented with the 32 bit DSN. However, when I try to load the data, it fails saying there is incompatible architectures (32 vs 64 bit). I tried to use VS 2022, but the Microsoft.DataTools.AnalysisServices add-in, but it says it's not compatible. Is there a way to develop with the 32 bit source (although I can't even load the data) but deploy with the 64? How am I supposed to use Analysis Services with MongoDB?

For a bit more clarity, the use case here is to enable Power BI reporting. I would use Power BI directly, but some of the data sets are too large for the limits in Power BI (any version including Premium).

Thank you!

Azure Analysis Services
Azure Analysis Services
An Azure service that provides an enterprise-grade analytics engine.
345 questions
No comments
{count} votes

Accepted answer
  1. Jon 101 Reputation points

    I was able to solve this by using the same name for both the 32 and 64 bit DSN's. Hope this helps someone else!

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful