Hi - I need some recommendation in Azure SSAS
We have Power BI dashboards connected to Azure Analysis Service model. Our Cube refresh everyday, however sometimes cube may fail while processing due to invalid/bad data. Since we don't have unique/foreign, etc. constraints available in Synapse pool we can't enforce the data integrity at database level. Can the cube still be accessible from Power BI if the processing fails. What is critical here is availability of the data to Power BI dashboards no matter if the the data is not up to date. I believe we can't cache the Cube data in Power BI site and connection type will be Live.
Is it possible to keep the two copies of the Cube, one(Reporting Cube) used to connect the Power BI and another one will be used to get the latest data from database pool and synchronize it to Reporting cube after successful processing.
Please suggest some recommendations..
Thanks