Forum Discussion

Anonymous

Not applicable

4 years ago

Solved

Data Mart Capacity Error msObserableUniverseHasChanged

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!

Anonymous
4 years ago
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....

5 Replies

otravers
Community Champion
4 years ago
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?
- Anonymous
  Not applicable
  4 years ago
  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....
  - Anonymous
    Not applicable
    4 years ago
    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.