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
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