Forum Discussion

mike_asplin's avatar
mike_asplin
Icon for Helper V rankHelper V
1 year ago

Help using SQl to limit the data being pulled form Microsoft Dynamics by Odata

I current have a model that is pulling whole tables of data form Microsoft Dynamics anbd then doing al lthe filtering in Power query.  Is therer a way to do the filtering at source like you woudl wit...
Need Help
mike_asplin's avatar
mike_asplin
Icon for Helper V rankHelper V
1 year ago

Seems ot be taking for ever. Can I check there arent any typoes

 

Whats the ge for?

FilterQuery = "$filter=starttime ge " & FilterDateText,

 

Why is time surrounded by TT and Z?

    FilterDateText = DateTime.ToText(Dateparameter, "yyyy-MM-ddTTHH:mm:ssZ"),

 

Thanks

v-lgarikapat's avatar
v-lgarikapat
Icon for Community Support rankCommunity Support
1 year ago

Hi mike_asplin , 

 

Thanks for reaching out to the Microsoft fabric community forum

Cookistador , FBergamaschi 

Thanks for your prompt response,

1.

FilterQuery = "$filter=starttime ge " & FilterDateText,

ge is one of the OData comparison operators, and it stands for:

ge = Greater than or Equal to

It’s the OData equivalent of SQL’s >=. So when you write:

text

$filter=starttime ge 2025-08-01T00:00:00Z

2. 

 FilterDateText = DateTime.ToText(Dateparameter, "yyyy-MM-ddTTHH:mm:ssZ"),

T

Time separator between date and time

2025-08-01T00:00:00

 

Z

Zulu time (UTC) indicator

2025-08-01T00:00:00Z

 

Open Data Protocol (OData) - Finance & Operations | Dynamics 365 | Microsoft Learn

 

We truly appreciate your continued engagement and thank you for being an active and valued member of the community.

If you're still experiencing any challenges, please don’t hesitate to reach out   we’d be more than happy to assist you further.

 

We look forward to hearing from you.

Best regards,
Lakshmi

 

  • v-lgarikapat's avatar
    v-lgarikapat
    Icon for Community Support rankCommunity Support
    1 year ago

    Hi mike_asplin ,

     

    We’d like to confirm whether your issue has been successfully resolved. If you still have any questions or need further assistance, please don’t hesitate to reach out. We’re more than happy to continue supporting you.

    We appreciate your engagement and thank you for being an active part of the community.


    Best Regards,
    Lakshmi.

    • mike_asplin's avatar
      mike_asplin
      Icon for Helper V rankHelper V
      1 year ago

      Hi sorry I'm getting same error . The step above seems to produce a table so maybe this step isnt needed? 

       

      • mike_asplin's avatar
        mike_asplin
        Icon for Helper V rankHelper V
        1 year ago

        Took this step out and works but extremely slow and in fact crashed 

    • theferret's avatar
      theferret
      Frequent Visitor
      11 months ago

      Hi sorry on holiday in Brazil so will check when I get back next week

      • v-lgarikapat's avatar
        v-lgarikapat
        Icon for Community Support rankCommunity Support
        11 months ago

        Hi mike_asplin ,

        Thank you for the updates. Please continue posting them here they’ll be very helpful

         

        Best Regards,

        Lakshmi.