cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
dustinb
Frequent Visitor

Can't Make Changes to Model After Connecting to Dataset

I've started a new pbix file and successfully made a live connection to a dataset, but I cannot make any changes to the model or add in any other data sources (options are greyed out or non-existent). I followed the documentation instructions by checking the right option and restarting. Any ideas?

 

pbi2.JPG

 

 

pbi3.JPG

 

 

pbi1.JPG

15 REPLIES 15
v-janeyg-msft
Community Support
Community Support

Hi, @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-s... ..............

Hi, @masok2 

 

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. 

Hi, @masok2 

 

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

But I have Multidimensional not Tabular so any other advice than "using Tabular is better"? We paid for Multidimensional and we pay for Power BI, both Microsoft solutions. 

Hi, @masok2 

 

Sorry. That's it, there is no good way. You can submit your idea to help us improve powerbi:Ideas (powerbi.com)

 

Best Regards

Janey Guo

jdbuchanan71
Super User II
Super User II

@dustinb 

This is correct.  There is a .pbix that has the actual data model in it, the one you published to PowerBI originally.  Your new file is just linking to that model.  You would have to make changes to the model in that original .pbix file and publish it again.

I should be able to make a composite model and add in other data sources, no?

This is what I'd expect to see:

 

Inkedimage-11_LI.jpg

Hi, @dustinb 

 

Yes, You need to click the button 'make changes to the model',then it will change to DQ and you can do other options.

 

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.

Yes, the whole issue is that those options do not appear for me. The screenshot I marked is not my own.

Hi, @dustinb 

 

We can't see where your problem is. So, Can you share the screenshot of your bottom right corner?

 

Best Regards

Janey Guo

Hi,@kabanowster 

 

The problem I said is not that you have no problem, but that we can't find the basis for judging the problem from your description.Thanks!

"We can't see where your problem is"? Do you have problem reading English?

 

The button to "make changes" is missing for me too. I have set the preview feature for Direct Query like the OP. After connecting live to dataset I can't make a composite model from it.

hi @kabanowster,
You must have the datasets in a different workspace than "my workspace". Try it and tell me.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

July 2021 Update 768x460.png

Check it out!

Click here to read more about the July 2021 Updates

Top Solution Authors
Top Kudoed Authors