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.

      • SBGoh's avatar
        SBGoh
        Helper I
        3 years ago

        Hi,

        Is it possible not to load all the data when applying the changes?