Power Query in Bi Service Does not Show Recent Data

[HabibAdil]

Hi All,

I created a datafow, but it does not show the recent data (Quotes Sent this month). When I read the same data from our ERP then it appears in power query. I have other dataflows which work fine. I don't have any complicated transformation, just selected some columns. Please can someone suggest any solution? Thanks

[v-yiruan-msft]

Hi @HabibAdil ,

Which data source be used in this dataflow? And could you please if the related underlying data source did exist these recent data?

Best Regards

Rena

[HabibAdil]

Thank you for your response. The data exists in the data source. Please see below a screen shot of the data which is extracted from from the ERP/data source using Crystal report. It is only the Quotes table that is missing the values. The values are only missing if I create a data flow or link directly to Quotes table from power bi desktop (New report below). I have an older report that reads exactly the same table, but no values are missing (Old Report below). 

[HabibAdil]

Update: Another colleague tried to connect to the data source through ODBC and he can see the recent data (Date_Sent). I restarted my computer and now I can connect to the data source through ODBC and see the recent data, however the dataflow still does not pick up the recent data (refreshed manually).

[v-yiruan-msft]

Hi @HabibAdil ,

Thanks for providing these information. Could you please try to create a new dataflow with the same data source and same operations then check if it can get the most recent data?

Best Regards

Rena

[HabibAdil]

Hi, I have already done that, it works. I wanted to know why this happened, it may lead to issues if this happens to data that is not so obvious to spot. Thanks