cancel
Showing results for 
Search instead for 
Did you mean: 

PowerBI Datamart not attaching to Dataset after refresh

I have been working within PowerBI Datamart (preview) creating a star schema model for reporting. After I saved/refreshed the datamart yesterday around 3PM CST, it is no longer accessible or attaching to the dataset. Below are the details I captured from the error I received. Please let me know if this is something someone can help with. Thank you.

 

 

Activity ID: c47b4a95-0e99-4e1d-8353-8d5668905b63
Request ID: 9430b379-d983-4615-85b2-5383f64fabec
Correlation ID: e2241105-0023-28d6-5ea4-b68d27000a93
Status code: 400
Time: Tue Sep 27 2022 07:47:45 GMT-0500 (Central Daylight Time)
Service version: 13.0.19134.41
Client version: 2209.3.13354-train
Cluster URI: https://wabi-us-central-a-primary-redirect.analysis.windows.net/

Status: Investigating

Hi @cosikes 

Does this error occur when you refresh datamart ? Can you gateway work normally ?

 

Best Regards,
Community Support Team _ Ailsa Tao

 

Comments
Ailsa-msft
Community Support
Status changed to: Needs Info

Hi @cosikes 

What is the data source of your datamart ? What authentication are you using to access the data source ? 

 

Best Regards,
Community Support Team _ Ailsa Tao

cosikes
Regular Visitor

I'm accessing a local SQL server db through an on-premise data gateway. It's windows credentialed and is accessible without issue through PBI Desktop when this is occurring. Thank you for reviewing.

Ailsa-msft
Community Support
Status changed to: Investigating

Hi @cosikes 

Does this error occur when you refresh datamart ? Can you gateway work normally ?

 

Best Regards,
Community Support Team _ Ailsa Tao

 

Rezki_Karar
Regular Visitor

Hi @Ailsa-msft 

I am actualy having the same issue, my data source is dataflows.

this happen very often at least once every 3 days. do we know what drives the disconnection to the dataset so we can avoid it.

 

Activity ID: d364d501-d6d0-4f2f-8ab7-dea960375ad7
Request ID: b7c3d2e1-a2ee-4e94-8e2c-5065e5ec5851
Correlation ID: 5933807c-7d41-b881-57ae-9d0aeb647e58
Status code: 400
Time: Tue Oct 04 2022 08:37:50 GMT+0100 (British Summer Time)
Service version: 13.0.19183.51
Client version: 2209.4.13431-train
Cluster URI: https://wabi-north-europe-redirect.analysis.windows.net/

cosikes
Regular Visitor

Hello, this has been occurring again and seems to have gotten worse today. I went about a week with good success until it presented itself again. Does anyone know when the datamart product will be released and generally available? Thank you.