Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
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
To learn more about Power BI, follow me on Twitter or subscribe on YouTube.
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...
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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
118 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |