Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

DirectQueryUnexpectedEndofStream - Cannot refresh partitions of dataflow

Hello,   I'm using Premium Per User and have a dataset that has incremental refresh set up for a table fed by a dataflow. The dataflow itself refreshes without issue. But the dataset with this data...
Dataflow
Need Help
v-janeyg-msft's avatar
v-janeyg-msft
Community Support
4 years ago

Hi, Anonymous 

 

 

Can you explain what it means? I suspect the problem is here. 

Try to open the editor in dataflow table to load and save the latest results.

 

Best Regards,
Community Support Team _ Janey

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Here is the M query used in my dataset:

    let
    Source = PowerPlatform.Dataflows(null),
    Workspaces = Source{[Id="Workspaces"]}[Data],
    #"e27448b9-41fa-4495-8525-98c9b5490c04" = Workspaces{[workspaceId="e27448b9-41fa-4495-8525-98c9b5490c04"]}[Data],
    #"2d70672f-47eb-4b18-bd9b-4d169c158bf8" = #"e27448b9-41fa-4495-8525-98c9b5490c04"{[dataflowId="2d70672f-47eb-4b18-bd9b-4d169c158bf8"]}[Data],
    #"InvoiceItem with PersonID_" = #"2d70672f-47eb-4b18-bd9b-4d169c158bf8"{[entity="InvoiceItem with PersonID",version=""]}[Data],
    #"Filtered Rows" = Table.SelectRows(#"InvoiceItem with PersonID_", each [DateCreated] >= RangeStart and [DateCreated] < RangeEnd),
    #"Changed Type" = Table.TransformColumnTypes(#"Filtered Rows",{{"DateCreated", type date}}),
    #"Removed Columns" = Table.RemoveColumns(#"Changed Type",{"DateApplied", "Active", "StartDate", "EndDate", "SiredByInvoice"})
in
    #"Removed Columns"

     

    • v-janeyg-msft's avatar
      v-janeyg-msft
      Community Support
      4 years ago

      Hi, Anonymous 

       

      When defining the RangeStart and RangeEnd parameters, we must choose the datetime type. Later, if you change the fields that need to be filtered to the date type, then they do not match, which may cause the incremental refresh failure. You can try to change it back to datetime and try again.

      Other troubleshoot about incremental refresh:

      Troubleshoot incremental refresh and real-time data in Power BI - Power BI | Microsoft Docs

       

      Best Regards,
      Community Support Team _ Janey

  • LynnZhang's avatar
    LynnZhang
    New Member
    4 months ago

    Same problem,too, do you solve it now?