Forum Discussion

masplin's avatar
masplin
Icon for Impactful Individual rankImpactful Individual
3 years ago

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 spreadhseet...
Need Help
GilbertQ's avatar
GilbertQ
Icon for Super User rankSuper User
3 years ago

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

  • masplin's avatar
    masplin
    Icon for Impactful Individual rankImpactful Individual
    3 years ago

    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.