question

Jon-7936 avatar image
0 Votes"
Jon-7936 asked PRADEEPCHEEKATLA-MSFT commented

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

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

azure-analysis-services
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

Jon-7936 avatar image
1 Vote"
Jon-7936 answered PRADEEPCHEEKATLA-MSFT commented

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

· 1
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Hello @Jon-7936,

Glad to know that your issue has resolved. And thanks for sharing the solution, which might be beneficial to other community members reading this thread.

0 Votes 0 ·