Data Mart Capacity Error msObserableUniverseHasChanged

[bryanshaw46]

I entered a query to another SQL Server and I got this error:  Data Mart Capacity Error msObserableUniverseHasChanged

What does that mean and how can I fix it?

Thanks for the help!

[otravers]

Do you mean that you created a native database query in the datamart's Power Query?

https://docs.microsoft.com/en-us/power-query/native-database-query

- Do you have that error while previewing data in Power Query or on load?

- Does that same query work in a dataflow?

[bryanshaw46 · Accepted solution]

It looks like the trick is to just connect to the server and database and not give it a SQL statement in the query.  Then I can alter the source and it works.  Strange....

[bryanshaw46]

Unfortunately, the issue is back.  I cannot schedule a refresh.  Both queries are to 2 different servers.  If I remove one of the servers, everything is fine.

[bryanshaw46]

More strangeness, I am not getting the error today.  Totally wierd.  Maybe a bug.

[otravers]

Most likely a bug, Datamarts are in Preview and it clearly shows with a bunch of random errors!