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!

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 SBGoh 

         

        It will only go as fast as your connection and SQL Server can send the data through.