Two Errors When Refreshing Report in PBI Desktop

[Belgarion42]

Hello!

One of my fellow developers has been working on a report that has as its data sources a couple of Excel files on SharePoint and a couple of Direct Queries of sematic models. Starting a few hours ago, he began to get this error:

When I attempted to troubleshoot for him, I got this different error:

I have no idea what to do about either error. The second one (the one I am getting) is the strangest to me, because I don't have a table named anything close to "LocalDateTable_34241b3a-b2a0-4492-b9ab-d6acba0980", nor do I know how to set the ShowAsVaraiationsOnly property.

Any help would be appreciated!  

[sergej_og]

Can you find this table using Tabular Editor?
Good tool to see your entire model and "hidden" tables.

Regards

[Belgarion42]

I've been using Power BI for a couple of years, but I don't think I've ever used that tool. It does seem really useful, and I see several of those "LocalDateTable_" tables. This and the Power BI Helper are the only places I can see them, though. Once I've identified them here, is there a way to delete them?

[Belgarion42]

Hey @sergej_og, thanks for the suggestion. Based on the research I'd done, I knew that might be a problem, so I did uncheck it--but not in both places, so thank you for pointing out the other one.

Unfortunately, even after unchecking Auto Date/Time, I'm still getting the same error. I even closed and reopened the file and tried again, and I'm still getting it.

[sergej_og · Accepted solution]

Hey @Belgarion42 ,
sounds like you have an active 'Auto date/time'. 

Don't recomend to do this.