SQLite query returns out of date info

Post a reply

:D :) :( :o :-? 8) :lol: :x :P :oops: :cry: :evil: :roll: :wink:

BBCode is ON
[img] is ON
[flash] is OFF
[url] is ON
Smilies are ON

Topic review

Expand view Topic review: SQLite query returns out of date info

Re: SQLite query returns out of date info

by FEB » Fri May 10, 2019 8:59 am

For anyone reading this somewhere down the line, it looks like it's a Power BI issue. I queried the same database with Excel's Power Query and it returned up-to-date information. I'm not sure what Power BI's problem is yet, but it's not a Mediamonkey issue.

SQLite query returns out of date info

by FEB » Wed May 08, 2019 3:40 pm


I've set up an ODBC connection to my MM.DB so that I can make my own reports, but I notice that the data it returns is missing music added less than 21 days ago. My ODBC connection is pointing to a MM.DB dated 7/5/19, but it doesn't contain anything added after 18/4/19 in it. I've searched to see if there's a different MM.DB anywhere, but the ones I've found are much older so I'm sure I'm pointing to the right one (C/Users/Me/AppData/Roaming/Mediamonkey). I've run a Trixmoto script (Custom Report Auto) to report from MediaMonkey and it shows all songs.

I don't know why this is happening. I've only just set the connection up so it might be something I've done wrong, but I don't know what else to test. I'm using Power BI to make my reports, if that's any help.