Forum Discussion

BugmanJ's avatar
BugmanJ
Icon for Helper V rankHelper V
2 years ago

How 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...
Need Help
BugmanJ's avatar
BugmanJ
Icon for Helper V rankHelper V
2 years ago

Thanks that really helpful.
I now suffer with this problem:
Details: "This server does not support Windows credentials. Please try Microsoft account authentication."

But no where does it give me the ability to enter MS account details?

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

That'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.

  • BugmanJ's avatar
    BugmanJ
    Icon for Helper V rankHelper V
    2 years ago

    Must 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.