Forum Discussion

PremK's avatar
PremK
Resolver I
1 year ago
Solved

Date Table in Direct Query is not working || Emergency

My Data source in MongoDB Atlas. i have created a View table in MongoDB Atlas and connected it to PBI through Direct Query mode for real time data visuals.  Created Date Table in 2 ways  1. static ...
Need Help
  • PremK's avatar
    PremK
    1 year ago

    Hii All, nothing worked at all.

    so i created a View collection in MongoDB with all the required fields and date fields. then connected with PBI and it worked 90%

maruthisp's avatar
maruthisp
Super User
1 year ago

Hi PremK,

Can you try below steps:

Use composite model:

Keep your main table in DirectQuery.

Create a Date table in Import mode - CALENDAR(DATE(2025, 1, 1), DATE(2025, 12, 31)

Use “Manage Relationships” to create a relationship.

Enable “Storage Mode: Dual” for the Date table if possible.

Note: Composite models may not be fully supported with MongoDB connectors depending on the connector you're using (ODBC, custom, or native).

 

Please let me know if you have further questions. Thanks in advance!

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated — thanks! 

 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X