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: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

MVeatch

Power BI Datamart won't load or connect to data sets

Submitted by on ‎04-10-2023 01:08 PM

Suddenly my datamart won't connect to the datasets so I'm unable to edit the measures or tables.  Additionally this issue is also resulting in my datamart no longer being able to refresh.  Last time this occurred the issue resolved itself over the weekend but this time the issue seems to be persisting and I'm not able to access the datamart to modify it but I am still able to connect to it via Power BI desktop and through the online service if I'm building a report and using it as the data source.  Any tips or help would be extremely appreciated.  

Activity ID: 0c481c43-4298-4232-abb7-270206effd2c
Request ID: 7f43eb83-3ee9-4cd4-b828-c9487cb903eb
Correlation ID: c37531bc-a034-a59a-5a2b-31bb109fcf33
Status code: 400
Time: Mon Apr 10 2023 14:59:39 GMT-0500 (Central Daylight Time)
Service version: 13.0.20442.57
Client version: 2304.1.13131-train
Cluster URI: https://wabi-us-north-central-e-primary-redirect.analysis.windows.net/

Status: Needs Info
See more ideas labeled with:
3 Comments (3 New)
Comments
MVeatch
Frequent Visitor
‎04-10-2023 02:00 PM

Also, the datasets it is connected to are PowerBI data flows which are refreshing correctly with no 

Anonymous
Not applicable
‎04-10-2023 06:34 PM

Hi @MVeatch 

Did you create the datamart directly from the dataset? What is the dataset's corresponding data source? What kind of errors are reported when you modify or refresh the datamart?

 

Best Regards,
Community Support Team _ Ailsa Tao

MVeatch
Frequent Visitor
‎04-11-2023 07:10 AM

Hi @Anonymous ,

The dataset is actually just type is listed as default because there isn't actually a data set like with your typical PBI reports when they are published.  The data that feeds my datamart are a handful of dataflows that exist in my workspace.  If I click on the dataset it just reflects the reports that are tie to the datamart as well as the a list of tables that are in my datamart. When I click on the red error triagnle next to my datamart it says,
"Datamart is unavailable

Unable to open the datamart because it is not connected to its dataset. Wait a few seconds, and then try again."

If I click on the (...) next to the datamart and select edit the same error message above pops up.  It does sometimes give me the option to try and connect to dataset and when I select it, it will spin and then I get a notification that claims it is connected to the dataset again but the error triagnle still exists and again if i try to click on the datamart or try to click on the (...) and select edit both options will result in the error message indicating the datamart can't open because it isn't connected to it's dataset.  
 
All of the dataflows that populate the datamart are dataflows that exists in the same workspace and they are all refreshing daily with no errors.  One recent change I had made was to duplicate an existing "query" within the datamart.  After I made that additional table within the datamart is about the time when the issue arised.

Here is the message I get when I do click (...) and select edit:
  • Activity IDb628bef9-da52-4eb6-bbba-88259a6e26f9
  • Request ID0fdff5f1-e5fe-41e7-b21e-53eca1ed2637
  • Correlation ID73fb6594-a4d4-865c-fa1a-81ebc79547d2
  • Status code400
  • TimeTue Apr 11 2023 09:18:40 GMT-0500 (Central Daylight Time)
  • Service version13.0.20442.57
  • Client version2304.1.13131-train
  • Cluster URIhttps://wabi-us-north-central-e-primary-redirect.analysis.windows.net/


Idea Statuses