Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
masplin
Impactful Individual
Impactful Individual

Failed to refresh combined model

Hi

 

I have 2 models published out on the service. One automatically refreshesevery 2 hours as all the data comes from Microsoft dynamics . The other one is done weekly using downlaoded spreadhseets, refreshed in desktop them published out

 

I created a combined model using the get data Power BI datasets. This model works fine refreshing in desktop, but once published othe service it is just dead in the water. I assumed it woudl pic up changes to the other 2 models automatically?

 

Instead i get this error if I try to manaully refresh it. I dont understrand the point of combined modles if the data doesn't update?  Can anyone explain as doesn't make sense to me?

 

Thank for any advice

Mike

 

Data source error:{"error":{"code":"Premium_ASWL_Error","pbi.error":{"code":"Premium_ASWL_Error","parameters":{},"details":[{"code":"Premium_ASWL_Error_Details_Label","detail":{"type":1,"value":"Refresh is not supported for datasets with a calculated table or calculated column that depends on a table which references Analysis Services using DirectQuery."}}],"exceptionCulprit":1}}}
Cluster URI:WABI-UK-SOUTH-B-PRIMARY-redirect.analysis.windows.net
Activity ID:f1b9089d-36a0-4b8f-ab56-b1fa41a2f95e
Request ID:627aed45-9579-4eeb-8826-e11f34c50d81
Time:2023-02-17 19:50:53Z
2 REPLIES 2
GilbertQ
Super User
Super User

Hi @masplin 

 

This is not working because you cannot have a calculated table or column which is connected to another dataset which is using DirectQuery.

 

What it appears is that your dynamics model is using DirectQuery which is causing the error when combining the datasets





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

masplin
Impactful Individual
Impactful Individual

There doenst seem any choice but to use direct query.   so once you have combined your datset you can use measures, but not calcuated columns/table in the new combined model?  It apears the data has started updating if I just hit refresh the webpage it picks up latest from the 2 underlying models so maybe it doens't need refreshing. Wasnt sure how a combined modle got updated.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors