Forum Discussion
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 ...
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%
Hi PremK you can try by creating a physical date table directly in MongoDB Atlas covering your needed date range and importing it via DirectQuery. Ensure the date columns in both tables match in format (date-only) and build a relationship between them. Use the date table slicer to filter your visuals and mark it as a Date Table in Power BI for time intelligence functions. Avoid using DAX-generated date tables in DirectQuery mode, as they often don’t filter correctly.