Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Helper III'm actually having the same problem. I have tried to connect both to a SSAS tabular model and then also a Power BI dataset from a file I have published. None of these connections gives me the option to connect to another data source.
Now when I see that you say it won't work when connecting to a (on-prem) SSAS model, can you then say when this will be possible?
We are running everything on-prem but I have a Power BI Pro license and it was the dataset of one of the models I have published here I tried to connect to. I get the connection to the dataset and see the model, but I'm not able to add any additional data.
I have checked that the preview fetaure have been enabled and also restarted Power BI.
Microsoft EmployeeOn-premises SSAS is probably coming in the next major release of SQL Server. Unfortunately I don't know when that is going to be.
Regarding the dataset: please make sure the dataset is not in "My Workspace".
- steen_p
Ok - connecting to a dataset that is not in "My workspace" actually made that part work.
Unfortunately, it's not that useful when I'm not able to connect to a local SSAS instance, so we'll have to wait until the SQL Server upgrade comes out....☹️
- jeroenterheerdt
ok, "my workspace" is not supported (see the blog). SSAS support is something we are looking into for next major version of SQL Server.