OLE DB or ODBC error: Query (3, 24)

[Syndicate_Admin]

Good night

I'm getting the following error when trying to apply changes made to the Power Query Editor:

"Could not save modifications to the server. Error returned: 'OLE DB or ODBC error: Query (3, 24) Cannot find table 'LocalDateTable_ae743712-37ec-4b8a-9e1d-1e124c4a80c5'. Technical Details: RootActivityId: 369e1581-5e2a-4098-a689-ce6e404ea129 Date (UTC): 8/17/2023 1:34:29 AM. '."

I hope you can help me, I've tried everything and the same message keeps popping up.

Thank you.

[Syndicate_Admin]

Hello, thank you very much for responding. I was able to find the table with the error in Power Query, however when correcting it it keeps throwing me the same message. As a last step I tried to delete the table and it throws me the same message. It seems that it was a Power BI error.

[Idrissshatila]

Hello @Syndicate_Admin ,

it looks like there's a missing table or this "LocalDateTable" is referenced in a query then it's gone or changed name.

can you check all the tables in power query and see if they all refresh normally one by one to see which one is  having the error.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote For my Idea💡