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

Question

Hello,
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!
Jon

Answer 1

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!
Jon