MongoDB Atlas SQL (Beta) <> SQL in Power BI

Flavia_Santos_de_Almeida · 2024-04-29T18:21:24.246Z

Hi guys! Could you help me with a question?

I’ve connected to a federated database instance, by using the MongoDB Atlas SQL (Beta) in Power BI.

However, I didn’t find where I can use SQL, in Power BI, to query the data.

I want to bring to Power BI only the necessary data of the federated database instance, not all them… is it possible?

At the image, you can see the connection between the federated database instance and Power BI.

Thanks for the attention!

Flavia_Santos_de_Almeida · 2024-04-29T18:24:12.120Z

At this image, you can see the configuration of the Federated Database Instance used

Alexi_Antonino · 2024-04-29T18:50:40.966Z

Also, to get at the data within Power Query, you can use the front end functions to transform, unwind (arrays), flatten (objects).

Flavia_Santos_de_Almeida · 2024-04-29T19:30:34.401Z

Thanks!