Forum Discussion

f4v5cs6oy3vis7j's avatar
f4v5cs6oy3vis7j
Regular Visitor
4 years ago

Desktop app is not pulling in the extracted data

Hi, I've got an established Power BI file. It's populated from numerous Excel files on SharePoint. The report has, until now, worked relatively well; I open the Desktop, refresh the data, then publ...
Need Help
f4v5cs6oy3vis7j's avatar
f4v5cs6oy3vis7j
Regular Visitor
4 years ago

Hi Anonymous 

 

I have not edited any query in Power Query Editor.

But when I look at Power Query Editor, I can see recent data; Power Query Editor is extracting the most recent data. This is good.

 

When I press Refresh on the Power BI Desktop, the most recent data (which I know exists because I've seen it in Power Query Editor) does not display on the Desktop app.

 

The only way I've been able to get the Desktop app to show the most recent data is to delete the last line in the Power Query Editor, refresh the Desktop with this change, and then re-edit the Power Query Editor to re-add the line I've just deleted, and re-refresh the Desktop. But this needs to be done on every single Query.

 

Does this make sense?

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Hi f4v5cs6oy3vis7j ,

     

    If you use a method that meets your needs, it certainly makes sense.


    I have an idea that I don't know if it would meet your needs that you could use as a reference, which is to configure automatic page refresh for reports, detect changes to relevant content to implement the refresh, and perhaps apply the changes to desktop.

     

    Related link:

    Automatic page refresh in Power BI Desktop - Power BI | Microsoft Docs

     

    You can create a copy to try it out to know if the requirements can be met. If not, you may consider using your way.

     

    Best regards,

    Community Support Team Selina zhu

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

     

    • f4v5cs6oy3vis7j's avatar
      f4v5cs6oy3vis7j
      Regular Visitor
      4 years ago

      Hi Anonymous 

       

      Thank you for your response, but you're not understanding the issue and automatic page updates won't help.

       

      The correct data is being determined in Power Query Editor, but the correct data in Power Query Editor is not being passed to Power BI desktop.

       

      Power BI desktop is not receiving the latest data.

      That's the issue.

       

      And yes, whilst I might be able to perform a workaround this month, what about next month? Or the month after that? Will I be resigned to amending the Queries every month? This appears to be a defect which Microsoft needs to resolve.