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%

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
1 year ago

Hi PremK ,

Thank you for engaging with the Microsoft Fabric Community. It seems the issue may be related to how DirectQuery interacts with MongoDB Atlas. The recommended approach is to create a Date Table directly in MongoDB Atlas and link it to Power BI.

1. Build a Date Table in MongoDB Atlas using an aggregation pipeline or SQL Interface to cover your required date range. 

2. Connect the Date Table to your main dataset in MongoDB before importing it into Power BI. 

3. Check for query folding support, as certain transformations may not function correctly in DirectQuery.

4. Test filtering behavior using a smaller dataset to identify any potential limitations in Power BI.

 

Because DirectQuery has some restrictions, including schema changes and row limits, confirming these aspects will help ensure the Date Table operates correctly in Power BI.

 

Thanks for your responses maruthisp & Akash_Varuna .

 

If my response solved your query, please mark it as the Accepted solution to help others find it easily. And if my answer was helpful, I'd really appreciate a 'Kudos'.