Recent Records are not fetched from Power Query into Power BI Data view

[Anonymous]

Hi folks,

I am trying to get all the latest records from my table on GCP BigQuery in order for them to be reflected on my visuals in Power BI desktop. I used the provided "GoogleBigQuery" interface to bring all the data from my table to Power Query, and I could see the records with the latest timestamps on Power Query.

Howerver, after clicking on "Close and Apply" button, those new records are not reflecetd on data view, resulting in no information displayed on visuals when the last 1 month period filter is applied. Anyone has experienced similar issues? If so, any solution to address this issue?

(From data view I could not see any records with year 2022 timestamps)

[v-kkf-msft]

Hi @Anonymous ,

Please open a new "Blank" Query,  then go to the old query, click on "Advanced Editor", copy everything, then go back to the Blank query, click on Advanced Editor, and paste. finally, delete the old query and click apply. 

Similar thread: https://community.powerbi.com/t5/Desktop/Data-Not-Showing-Up/td-p/236485 

If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
Best Regards,
Winniz
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , Make sure you are checking the last step of the query.  Sometimes one may filter data for testing in power query and may leave the filter step. In the data view sort table on the date in descending order and check.

If load fails it should give error

[Anonymous]

@amitchandak 

Thanks for advising on what to watch for. However, I have double confirmed that there is no filtering applied on Power query and you can see the steps applied in the screenshot below.

Also, there was no load failure experienced afterwards. It is just that the latest records are not reflected on data view.