Direct Query for POWERBI

MongoDB Atlas
1

Hi when will be the direct query mode available for powerbi?

2

Hi @Anand_Reddy Welcome to the Community!
We are shooting for end of the year for the DQ support. This is my best estimate, and I will be sure to update the community when we get close.

3

Hi @Alexi_Antonino ,
Any news about this feature? Thanks

4

Hello @Sauro_Rossi The latest version that includes Direct Query has been submitted to Microsoft for recertification and approval. I expect they will ship it with Power BI within the next month (I am waiting to hear back on the Microsoft release). We have the DQ version available now within our Mongo DB Download Center. Just make sure to download the latest ODBC driver as well (version 1.2) Download Power BI Connector | MongoDB
Download Atlas SQL ODBC Driver | MongoDB

Let me know if you have any further questions.

Best,
Alexi

5

Thanks @Alexi_Antonino for the useful information.
We are looking forward for new Power BI release. In the meantime we can have a look in your internal release.

Best Regards
Sauro

6

Hi again @Alexi_Antonino,
is this solution also for “on-premise” Mongo deployment or for Atlas cloud solution only?

Thanks and regards
Ssuro

7

Hello @Sauro_Rossi This connector is only for our cloud db, Atlas. We are researching now what an on-premise equivalent would be and how best to build it, but we are in the early stages of the process. Until we have a solution for on-premise SQL Interface, our on-prem BI Connector is available for use.

8

Hi, any update on the Direct Query support that was submitted to Microsoft on march ?

9

Hi there @hari_gaire yes, our MongoDB Power BI Connector with the DQ support is available. We have had it available through our MongoDB Download center for quite a while and we submitted the version to MS back in March. I just saw last week that MS did certify this new version and I believe this will be shipped with the next release of Power BI (should land this month).

Let me know if you need more information, and welcome to the community!

1 Like
10

Hi @Alexi_Antonino , Hi, I would like to ask two questions. MongoDB are authoring article on MS pages MongoDB Atlas SQL interface connector (Beta) - Power Query | Microsoft Learn There is written that only import mode is supported. is that correct? it may be worth to update in regards to Announcing DirectQuery Support for the MongoDB Atlas Connector for Power BI | MongoDB
Second question relates to problems with RLS (Row-level security) in Power BI. We see an error Query can’t be folded while applying filter on string. Filtering based on number looks to work fine. is RLS supported at all?
thx
Jan

11

Greetings @Jan_Kerzel and welcome to the community.
Thanks for alerting me about the dated material on the MS site. Our latest update should have also updated the documentation, but obviously something didn’t work. I will work to get that updated.

Our latest version of the Power BI Connector does in fact support Direct Query. And we just released a new version of our ODBC driver that may resolve this folding error. If you are able to head over to our download center and download + install version 1.4.1, then see if the behavior is changed. Please report back if things are not resolved.

Best,
Alexi