Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Limiting data pulled from D365 FO into Power BI

I've successfully connected, and can pull entire entities into PowerBI, but given the size of our tables this takes a great deal of time.  I'd like to constrain what is pulled, say the last 7 days of...
Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    I think I solved my own problem.  

     

    Here's the query that worked.

     

    let
    Source = OData.Feed("https://xxxxx.sandbox.operations.dynamics.com/data", null, [Implementation="2.0"]),
    SalesOrderLines_table = Source{[Name="SalesOrderLines",Signature="table"]}[Data],
    #"Filtered Rows" = Table.SelectRows(SalesOrderLines_table, each Date.IsInCurrentQuarter([RequestedShippingDate]))
    in
    #"Filtered Rows"

Anonymous's avatar
Anonymous
Not applicable
6 years ago

I think I solved my own problem.  

 

Here's the query that worked.

 

let
Source = OData.Feed("https://xxxxx.sandbox.operations.dynamics.com/data", null, [Implementation="2.0"]),
SalesOrderLines_table = Source{[Name="SalesOrderLines",Signature="table"]}[Data],
#"Filtered Rows" = Table.SelectRows(SalesOrderLines_table, each Date.IsInCurrentQuarter([RequestedShippingDate]))
in
#"Filtered Rows"