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