Power Bi Desktop does not refresh data

[jvbs]

Hey,

Since the month turned, I'm trying to load April data in my Power Bi Desktop report to develop before pushing to web, but no matter what I do, it doesnt work at all! No errors displayed, I just click on refresh, and it loads only until 2020-04.

My data is from a SQL source and my DB table is updated and I can see 2020-04 data in it.

I already followed these steps bellow but nothing worked.

https://community.powerbi.com/t5/Desktop/Refreshing-Power-BI-desktop-files/m-p/474749

https://community.powerbi.com/t5/Desktop/Power-Query-and-Power-BI-Desktop-does-not-refresh-all-data/...

[mahoneypat]

Sorry if this is stating too simple a suggestion, but sounds like there is a filter in your query that is limiting the data loaded.  Or are you assessing using a visual with a Date table that doesn't cover the new dates (done that myself)?

If this solution works for you, please mark it as the solution.  Kudos are appreciated too.  Please let me know if not.
Regards,
Pat

[jvbs]

Hello @mahoneypat , great point, but no, there is no filter in my report, even if I open Power Query and filter, there is no 2020-04 listed there...

[v-yiruan-msft]

Hi @jvbs ,

Did you add a conditional clause for filtering when connecting to a SQL source in Power BI Desktop just like below screen shot? It is import mode, right? And could you please provide some screen shots of the related tables display in SQL Server and Power BI Desktop if it is convenient?

Best Regards

Rena