Forum Discussion
Helper VHow to avoid the problem of not being able to refresh Calculated Tables off Direct Query Tables
Super User
when i try, i have to cut down to the part which goes
api.powerbi.com
You need to keep that part. Remove the "Data Source=" part, and the "Initial Catalog" part including the semicolon.
The server part should be
powerbi://api.powerbi.com/v1.0/myorg/<workspace name>
The database part is the name of the semantic model.
Helper VThanks 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
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
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.