Forum Discussion
Solved
MongoDB Atlas SQL connection using 2 connections with 1 data gateway problem
I have a problem when I try to open my published report in Power BI service using two connections and one single data gateway. Context: I have a MongoDB Atlas DB exposed through a PBI Gateway. Insid...
Hi Anonymous
I contacted Microsoft support and they were helping me, but finally I managed to find a solution with my colleagues. It turns out that it is possible to create a kind of ‘view’ in a section that Mongo Atlas offers called Data Federation. There I put together both collections, each one from a different cluster and I only needed one connection for both Desktop and Service.
So as this has helped me, I'll give this answer as a solution.
Anyway, thank you very much for the help provided in your comments!
Also important to mention that I'm using DirectQuery, because when I publish the report with import mode it works well, but I need automatic page refresh function, so DirectQuery mode is obligatory for me.