Forum Discussion
Microsoft EmployeeShare your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)
Nope, the top ribbon is greyed out and also the right hand bottom side does not give the option to make changes to the model. Please see images below.
I have updated my Power BI desktop to the latest December, 2020 release as well.
Thanks,
Neha
Microsoft Employeeis the preview feature enabled? Also, re-reading your original post - your dataset that is live connected to SSAS will not work.
steen_pHelper II
I'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.
- jeroenterheerdt
On-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....☹️