Forum Discussion

PhilJones82's avatar
PhilJones82
Frequent Visitor
5 years ago

Query not updating after publishing

Hi

so I created a query and set of visuals in powerbi desktop. I published it and then setup a scheduled refresh using my personal gateway. 
later I realised one of the queries had an incorrect filter on one of the tables. 
I corrected that, and republished the report. Initially the data is correct, but once the scheduled (or manual) refresh occurs the data goes back to what it was before I corrected the filter. 
Anyone have an ideas why that is happening? I even published it under a new name and it does the same thing?!

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi PhilJones82 ，

     

    What data source and which connecting mode did you use before? Will the error also occur after you manually refresh on Power BI Desktop?

    If it does, it may be that your original data has changed.

    If not, please give me more details so that we can troubleshoot this problem.

     

    Best Regards,

    Yuna

    • PhilJones82's avatar
      PhilJones82
      Frequent Visitor
      5 years ago

      The data source hasn't changed, only that I moved the original pbi file from my computer to SharePoint. 


      I have since removed the incremental refresh from the tables in the pbi on SharePoint and republished them. 
      The data now seems to be refreshing but I will check again today after the next scheduled refresh

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hi PhilJones82 ,

     

    Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.
     
    Best Regards,
    Yuna