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: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

cosikes

PowerBI Datamart not attaching to Dataset after refresh

Submitted by on ‎09-27-2022 05:53 AM

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

 

See more ideas labeled with:
5 Comments (5 New)
Comments
v-yetao1-msft
Community Support
Community Support
‎09-29-2022 12:15 AM
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
‎09-29-2022 05:55 AM

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.

v-yetao1-msft
Community Support
Community Support
‎10-04-2022 12:24 AM
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
Frequent Visitor
‎10-04-2022 12:42 AM

Hi @v-yetao1-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
‎10-20-2022 11:29 AM

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.

Idea Statuses