Forum Discussion
Issue with multiple SSAS cubes (the visual has unrecognized fields)
The fix for this issue has been deployed to production (should have arrived ~mid-June).
If you are still having problems with this issue please let us know, so that we can find out if the issue has regressed again since then or if the fix did not cover your particular scenario.
Update: when monitoring the gateway server with fiddler, the JSON response to a non-working dimension had the following error:
Could not resolve model references in the Semantic Query. Affected items: [dimension name].
OK, so I tried again this morning, after the weekend, and suddenly everything of the second cube works. Without any intervention. However, now some visualizations from the first cube - who did work - are now not working. Weird.
Thanks for raising this issue koenverbeeck, we have looked into it and identified a caching issue in the PowerBI service for cases where there are multiple cubes for the same database.
A bug has been filed for the feature team. In the meantime, unfortunately there are not any workarounds we can suggest for the problem other than waiting 10-15min for the cache to clear in the service before opening the report.
OK, thanks for the feedback!