Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Prepping for a Fabric certification exam? Join us for a live prep session with exam experts to learn how to pass the exam. Register now.

Mat101

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

Submitted by on ‎03-30-2023 12:59 AM

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:

Mat101_0-1680162854151.png

 

“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 ? 

Status: Investigating
See more ideas labeled with:
1 Comment (1 New)
Comments
Anonymous
Not applicable
‎03-30-2023 11:23 PM

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

Idea Statuses