"We couldn't load your datamart" - after switching dataflow ID

[Mat101]

Our datamart was connected to dataflow in Direct Query Mode in worskapce A . In workspace B we have the same dataflow (the same data, column names, also Direct Query mode turned on).  

1. After switching the dataflow ID (and Worspace ID) in Power Query Advance Editor, the following error occured while loading data:

“Activity ID: f2b8c186-ef75-6db9-6a42-4b26517282cd

Request ID: 0c79424e-30fd-46b5-a2b7-cdf003594a6d

Status code: 500

Error Code: InternalError

Batch ID: 6cb2cf04-0e2e-4c29-a557-36eb34e2f698@b1e39f81-43fe-4de5-8a1c-c44fa07f57db$2023-03-29T14:56:26.187145...”

This error caused not possibility to access to datamart.

      2. Error visible now related with no possibility to open a datamart to perform some recovery:

“Activity ID: 32768a7c-273a-47c6-a839-3933d1c3b180

Request ID: 6da5c9eb-9d2f-45cf-8e84-ca871377b96d

Correlation ID: 8858ca98-bca6-2a9c-0dd9-6036dca3748b

Status code: 400

Time: Wed Mar 29 2023 18:43:33 GMT+0200 (Central European Summer Time)

Service version: 13.0.20342.55

Client version: 2303.3.12949-train

Cluster URI: https://wabi-us-north-central-e-primary-redirect.analysis.windows.net/”

Please advise how to recover this datamart and how to proceed with switching source in datamart without crashing it ? 

[v-xiaoyan-msft]

Hi @Mat101 ,

For the need "how to recover this datamart and how to proceed with switching source in datamart without crashing it", if you are a Power BI Pro licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.

The link of Power BI Support: Support | Microsoft Power BI

For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community

Best Regards,
Community Support Team _ Caitlyn