cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BhuvaraghanJK
New Member

Mongo DB Live/Direct Query

Hi All,

 

In data sources capabilities I saw (Link) , ODBC is only supported for manual refresh. Since we are using Mongo DB, ODBC is the only option. Is there any way to link the data using data query or live connection as we are planning to embed the dashboard in the tool we are building. Setting a manual refresh will not work in our scenario.

 

Thanks for the help.

1 ACCEPTED SOLUTION
RicoZhou
Community Support
Community Support

Hi @BhuvaraghanJK 

If your data source support Live or Direct Query in Power BI, you can choose the connection mode when you connect to your data source, just like SQL Sever, you can choose Direct Query or Import.

From the data source link, we can find that ODBC connector requires gateway to refresh the data source. So you need to configure your data source credential in gateway to refresh your report in Power BI Service.

1.png

I think manual refresh means use “Refresh Now” in Power BI Service to refresh the data source manually.

You can try schedule refesh in dataset setting after your configure gateway successfully. 

For reference: Install an on-premises data gateway

 Manage your data source - Import/scheduled refresh

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

View solution in original post

1 REPLY 1
RicoZhou
Community Support
Community Support

Hi @BhuvaraghanJK 

If your data source support Live or Direct Query in Power BI, you can choose the connection mode when you connect to your data source, just like SQL Sever, you can choose Direct Query or Import.

From the data source link, we can find that ODBC connector requires gateway to refresh the data source. So you need to configure your data source credential in gateway to refresh your report in Power BI Service.

1.png

I think manual refresh means use “Refresh Now” in Power BI Service to refresh the data source manually.

You can try schedule refesh in dataset setting after your configure gateway successfully. 

For reference: Install an on-premises data gateway

 Manage your data source - Import/scheduled refresh

 

Best Regards,

Rico Zhou

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

View solution in original post

Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Top Solution Authors
Top Kudoed Authors