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 UserThat's because you tried with the wrong authentication, and Power Query is mean and is remembering that choice. Go to the Data Source settings are clear the credentials. Then try again, with organizational account.
BugmanJHelper V
Helper VMust be an organisational setting somewhere as this is still failing yet a friend showed me how this would work in a different organisation. However it appears this will still bring in the all the data, the whole point of the summary of direct data it that it doesnt do this.
But thank you for the assistance. I will mark the above as a solution for those whom Organisations allow it.