Forum Discussion
Helper IDataflow returns "old" data
Please double check if you have the below setting enabled on your dataflow:
I am expecting you are using DirectQuery in dataflow as otherwise without refresh of data done at different times this issue can't happen.
Here is the link which might explain the functioning of direct query in Dataflows:
https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-premium-features
Helper IThank you for your reply Burningsuit
I understand your point but that is not the case.
In Power BI Desktop I am connected to the dataflow, not directly to the datasource.
Refresh history of the dataflow:
In mssql the table returns 30.876 rows:
Dataflow editor also returns 30.876 rows:
However, when I refresh the table in Power BI Desktop from the dataflow, it returns more rows.
Solution Supplier
Please double check if you have the below setting enabled on your dataflow:
I am expecting you are using DirectQuery in dataflow as otherwise without refresh of data done at different times this issue can't happen.
Here is the link which might explain the functioning of direct query in Dataflows:
https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-premium-features