Forum Discussion
Helper VHow to avoid the problem of not being able to refresh Calculated Tables off Direct Query Tables
Helper VThanks, when i try, i have to cut down to the part which goes
api.powerbi.com
It then gives the error: "We could not connect to the Analysis Services server because the connection timed out or the server name is incorrect."
What should be the correct name? Do i need a value in for the database? My original dataset is pulling data from a AWS if that helps
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.
- BugmanJ
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
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.