Forum Discussion
Solved
Calendar Table returning error: The expression specified in the query is not a valid expression
I am racking my brain. I am building a PBi dash from a SharePoint list. Before, the list had only a few lines of test data, so I had no problem creating the calendar table. However, I have a second d...
Try using the CALENDARAUTO() function, that will automatically scan all the date columns in the model and should return a valid table even in the presence of blanks.
lbendlin
Super User
Super UserCan't seem to reproduce the issue?
It's possible that it's a limitation in sharepoint as opposed to the plain export through excel, I obviously can't share the sharepoint data directly but that's the export so I'm not sure what else to say, I'm trying to build a new list as we speak