Forum Discussion
Helper VHow to avoid the problem of not being able to refresh Calculated Tables off Direct Query Tables
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.
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?
- lbendlin
You can connect to any semantic model as if it were an Analysis Server since a semantic model is pretty much an instance of SSAS Tabular.
In your workspace navigate to the semantic model's settings page. Go to the Server setting section and copy the connection string
Use that connection string in your new file. It will then give you the option to connect live or via import mode, and you can specify your own DAX query if you want.
- BugmanJ
Thanks, 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
- lbendlin
when i try, i have to cut down to the part which goes api.powerbi.comYou 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.