Forum Discussion
Two Errors When Refreshing Report in PBI Desktop
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!
4 Replies
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.
Can you find this table using Tabular Editor?
Good tool to see your entire model and "hidden" tables.
RegardsI'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?
