Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago
Solved

Data refresh successful but data remains same

Hi all, Hope all are doing good. Iam doing refresh in Power bi service , the refresh is happening without showing any error but data values not updating. Please help

Need Help
  • SBGoh's avatar
    SBGoh
    3 years ago

    Hi GilbertQ , I have solved the problem. It is due to underlying data where I am using native sql to get the data. I just fixed the sql. However apply the changes took a lot time. I have about 2 million records. I wonder it is normal to be slow and if there is any way to speed up ? I only select the fields that I need.

     

    Thank you!

6 Replies

  • SBGoh's avatar
    SBGoh
    Helper I
    3 years ago

    Hi, I also encountered some problem. I am using gateway to connect to Oracle DB. Refresh is completed but latest data is not displayed. Very weird. Using the reset button does not help.

    • GilbertQ's avatar
      GilbertQ
      Super User
      3 years ago

      Hi SBGoh 

       

      Does the data refresh if you use Power BI Desktop?


      I have never had an issue with refreshing data in the Power BI Service. It is typically either a filter on a page or the underlying source that does not have the new expected data.

      • SBGoh's avatar
        SBGoh
        Helper I
        3 years ago

        Hi GilbertQ , I have solved the problem. It is due to underlying data where I am using native sql to get the data. I just fixed the sql. However apply the changes took a lot time. I have about 2 million records. I wonder it is normal to be slow and if there is any way to speed up ? I only select the fields that I need.

         

        Thank you!

  • GilbertQ's avatar
    GilbertQ
    Super User
    3 years ago

    Hi Anonymous 

     

    Could you click on the reset to default button, as maybe there is a filter somewhere causing the data not to show as expected?