Forum Discussion
Can't Make Changes to Model After Connecting to Dataset
Community SupportHi, dustinb
There are some limiations in the new feature. You need to check it:
- Using the following sources as a DirectQuery source is not supported:
- SQL Server Analysis Services (SSAS). We plan to support SSAS Tabular models in the next major release of SQL Server. Support for SSAS Multidimensional models is not planned.
- SAP HANA.
- SAP Business Warehouse.
- Using DirectQuery on datasets that connect to SSAS using a live connection is not supported.
- Using DirectQuery on datasets from “My workspace” is not supported. This will be resolved shortly after public preview.
- Using Power BI Embedded with datasets that include a DirectQuery connection to a Power BI datasets or Azure Analysis Services model is not yet supported. We plan to support this as soon as possible.
Reference:Using DirectQuery for datasets and Azure Analysis Services (preview) - Power BI | Microsoft Docs
Best Regards
Janey Guo
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Since when "Using DirectQuery on datasets that connect to SSAS using a live connection is not supported." is valid? It was working some time ago and I used this approach to add measures on a top of Multidimensional Model which -as you know- is igorned by Microsoft and barely supported by Power BI. That was my only option to workaround and deliver what my Business expected. Now, I cannot edit these reports (add new measure etc.) nor create any new report which won't be understandable for my managers. Why was it disabled and ruined my work? Is it possible to return it? If no, what workaround you can propose me to add measures to Multidimensional Model (without loosing the structure of that model, I don't want to build it from zero by importing only data without predefined measures or relations).
Also that limitation, as you describe it, isn't still clearly mentioned in documentation here: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-services ..............
- v-janeyg-msft
Hi, Anonymous
It's difficult, I think you should ensure that the multi-dimensional model has been completed when imported into powerbi.
Best Regards
Janey Guo
v-janeyg-msft Sorry but it's not an advice, feels rather as a joke out of me.
For example, I have to prepare a new report with ONE table showing: measure one filtered on Time dimension to 2019 and in the same table I need second measure filtered on Time dimension to 2020. What’s your solution for this on Multidimensional in Power BI? “write appropriate measures on cube” is not an option to me. Especially that without Direct Query for datasets based on SSAS, Power BI doesn’t see hidden measures (and to compare: you can easily use them in Excel, that is ridiculous) and I won't proceed adding measures which are simply previous measures crossed with dimension because our cube has >1K users and the won't agree for such a mess!!!! I was able to write “new measures” which were simply filtered versions of measures or showing hidden measures but I’m no longer able to do it so please, propose a solution. If there’s none, then I demand the feature of "Using DirectQuery on datasets that connect to SSAS using a live connection" to be supported AGAIN because that one was working and I have reports to prove it.
- v-janeyg-msft
Hi, Anonymous
Tabular models provide users the ability to create implicit measures such as count, sum, or average on fields. For multidimensional models, because dimension attribute data is stored is stored differently, querying implicit measures can take a long time. Because of this, implicit measures against multidimensional models are not available in Power BI.
Powerbi has limitations for multi-dimensional models. This is the fact. You can only perferct the model in SSDT.
Reference: DAX for multidimensional models in SQL Server Analysis Services | Microsoft Docs
Best Regards
Janey Guo