I see a message that the datamart cannot be opened because it is not connected to its dataset. This message appeared after I tried to refresh the datamart.
Prior to this issue, I noticed the following issues with this datamart.
- Sometimes the scheduled refresh would fail, but an on-demand refresh would work.
- Unable to modify relationships. I tried changing relationship from both to single and this failed. I then tried to delete the relationship and that failed. I received a message that it was reverted back to the last save.
- When a dataflow had a column added, the datamart didn't handle this smoothly. I had to open datamart, go to transform data (get power query open), refresh table, then save. That seemed to help the datamart pickup the added column in the dataflow.
- Dataset created from dataflow had different last refresh date/time than the datamart. The dataflow seemed to show the date/time of when it was first created. After the datamart refreshed, I did not see the dataflow last refresh date/time change.
- Could not see refresh history for datamart.
Hi @eliz_psu,
There is an existing ICM for this kind of issue(ICM 317788142). According to the reply from the product group, this Datamarts should has been suspend. They has filed the bug and will release a fix for it to prevent a Datamarts go into unavailable state. But for the Datamarts that has been the unavailable state, they suggest replacing it with a new one. In the new Datamarts, you need reduce the data amount to avoid the error again.
Per our policy, we’d suggest you one problem in one post so we can focus on one issue to prompt the investigation. If you still have problems on, then please provide more info on it in new posts. Thanks for your understanding!
Best Regards,
Community Support Team _ Caiyun