web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

Community site session details

Community site session details

Session Id :
Microsoft Power Up Program Community
Unanswered

No loan data for April to October pulling through

(1) ShareShare
ReportReport
Posted on by 4
I've about halfway through the "Visualize school library data with Power BI" section and refreshed my loans data this afternoon to pull through overdue loans.
Since then my matrix is only pulling through loans from Nov, Dec, Jan, Feb & Mar for each school year and any loans without dates in these months are in a section on their own.
 
I've also been looking at the data in the loans table that was pulled down from Dataverse, just to make sure there are loans that started in May and there are multiple records with Due Dates earlier than the loan start date. 
 
My tables are connected dimDate Date to Loans Date Loan Start as per the video.
 
 
Any ideas what may have caused this or how to fix?
Categories:
I have the same question (0)
  • Verified answer
    w.p Profile Picture
    8,339 Super User 2025 Season 2 on at
    -If you could share your BI file, it would be a lot easier to assist.
    -One of the known issues in this module is the difference between the Date/Time and Date only data types.
    -You might try creating a blank BI file to see if that helps resolve the issue.
    -I’d recommend joining the weekly live Q&A session, where the instructor can guide you through each step.
  • w.p Profile Picture
    8,339 Super User 2025 Season 2 on at
    Has the issue already been resolved?

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Forum hierarchy changes are complete!

In our never-ending quest to improve we are simplifying the forum hierarchy…

Ajay Kumar Gannamaneni – Community Spotlight

We are honored to recognize Ajay Kumar Gannamaneni as our Community Spotlight for December…

Leaderboard > Microsoft Power Up Program Community

#1
timl Profile Picture

timl 512 Super User 2025 Season 2

#2
Michael E. Gernaey Profile Picture

Michael E. Gernaey 82 Super User 2025 Season 2

#3
mmbr1606 Profile Picture

mmbr1606 62 Super User 2025 Season 2

Last 30 days Overall leaderboard