Forum Discussion
BugmanJ
Helper V
Helper VHow to avoid the problem of not being able to refresh Calculated Tables off Direct Query Tables
Good Afternoon All, Having fallen for the same problem I have seen many people suffer from on here, I am asking what is the best solution to avoid this? Problem You have a Dataset you are acce...
lbendlin
Super User
Super UserProblem
You have a Dataset you are accessing via DirectQuery. From this directquery, you build some summerised tablesThat's your problem all right.
Have you considered using the Analysis Services connector against the dataset semantic model? That will allow you to import tables. Not optimal but a good enough compromise.
BugmanJHelper V
Helper VHow would I do this? I believe from what I have read online that analysis devices would only connect to a server and not a semantic model?