Forum Discussion

HabibAdil's avatar
HabibAdil
Helper IV
6 years ago

Power Query in Bi Service Does not Show Recent Data

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

 

 

Need Help

5 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    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's avatar
      HabibAdil
      Helper IV
      6 years ago

      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's avatar
        HabibAdil
        Helper IV
        6 years ago

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