Forum Discussion
PBI Report Refresh Not Updating Power Query Editor Data
ISDG ,
Power query is for transforming the data and it doesn't actually store all the data, it shows only a sample of your data in order for you to transform it, it won't fit to show all the data.
so every time you want to see the updated data in power query you need to refresh it, and this doesn't mean the your report won't be updated unless you go and refresh the power query view.
Thank you for the reply. The report displays the updated dated immediately. When we open Power Query, we have to click on the specific table and click Refresh Preview before it will show the updated data. Why is the new data not showing in Power Query before doing a preview refresh?
ISDG ,
Power query is for transforming the data and it doesn't actually store all the data, it shows only a sample of your data in order for you to transform it, it won't fit to show all the data.
so every time you want to see the updated data in power query you need to refresh it, and this doesn't mean the your report won't be updated unless you go and refresh the power query view.
Makes sense, thank you!
I figured it out! This thread helped me pinpoint what was going on.
I checked the box below in the desktop dataset, saved it, and published it. Then, in Excel, I hit refresh, and everything magically aligned with the Power BI data online.
