cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
tessahurr
Microsoft
Microsoft

Share your thoughts on DirectQuery for Power BI datasets and Azure Analysis Services (preview)

Hit Reply and let us know what you think of the DirectQuery for Power BI datasets and Azure Analysis Services.  To learn more about this feature, please visit this blog post or our documentation.

 

Here are some areas that we'd like to hear about in particular:

  • Performance
  • Query editor experience--the remote model query doesn't show up in the query editor and only in the data source settings dialog. What are your thoughts?
  • Navigator experience
  • Thoughts around governance and permissions for models that leverage this feature
  • Nesting models, i.e. building a composite model on top of a composite model
  • Automatic page refresh for live connect in composite models

Thanks and we look forward to hearing your feedback!

 

- The Power BI Modeling Team

438 REPLIES 438
gengxuefei
Frequent Visitor

I have the similar issue like the topic listed below of refreshing the composite model dataset in service :

Error refreshing Composite model live connection t... - Microsoft Power BI Community

 

everything works fine for calculated table in desktop mode. However, when the dataset is published to the service, there will always be an SSO error message

 

@tessahurr @jeroenterheerdt is there any investigation on this topic? thanks! 

calculated tables in the Service are not yet supported.

Anonymous
Not applicable

Build Permissions Required on any dataset connected via Direct Query to Analysis Service?
This is a documented requirement. However, it has unintended ramifications. For example, when I connect to my HR dataset, I can publish only metrics that are not sensitive on my local dashboard. However, due to the requirement to have Build permissions directly on the HR dataset I have now exposed the full HR data model (via Power BI Desktop or Excel) to any user of my dashboard. This seems like an overshare and a security risk.

It is unfortunate, I feel like in it's current state it's unusable for Power BI Premium subscribers (with the potential re-use, it seems like enterprise deployments would benefit the most).

 

I would recommend voting for this feature on uservoice: Microsoft Idea  · Directquery for datasets only needs read permissions on all datasets (powerbi.com)

thanks for the feedback - we are currently investigating this

thanks for the feedback - we are aware of this and are investigating how to change this.

I hope this will be fixed in near future. I just started to use these new features and now it feels a little frustrating to realize all the end-users would need build rights to use the newly created reports.

this will be fixed.

Anonymous
Not applicable

Modifying the Direct Query to Analysis Services connection deletes all Joins and Measures created in the local model
Updating the Direct Query to Analysis Services connection to a new dataset in the same or new Workspace with exactly the same data model causes the local model to delete all related Measures and Joins created in the Local model. As a result when initially building a model against a Test data model, all Measures and Joins need to be recreated after connecting to the Production data model.

this is by design.

TWolsten
Frequent Visitor

Hi there,

 

I was wondering if there is a limitation with Premium Workspaces whereby you cannot use the recently released feature of direct querying datasets within premium workspace.

 

I have successfully connected multiple datasets which sit in non-premium workspaces but when I try and connect to a dataset within a Premium workspace I get the below error, and it is not a permission issue as I am the admin of the workspace:

TWolsten_0-1620668454508.png

 

 

 

 

Any help resolving this would be greatly appreciated otherwise I guess I will have to have a non-premium workspace for reports and premium for dataflows.

 

Thanks in advance! 

this should not have happened - can you open an issue on issues.powerbi.com please?

@jeroenterheerdt done 🙂

 

I'm assuming it was 'Post an idea' as there wasn't a 'Post an issue' button.

howellchrisj
Frequent Visitor

Currently connecting to AAS live and it works in PBI Desktop and PB Service.  When I change this to Direct Query so that I can do more with the model by adding new measures outside of AAS, it works in PBI Desktop, but I get a "Cannot Load Model" in PB Service.
I had someone someone check to ensure the endpoint is active, along with live connections in the Tenant settings are active.  Any thoughts on what else this could be?

This is holding up a project for a client.

@jeroenterheerdt , I see you have helped others, any insight?

 

this should not have happened as well (see a post above yours) - can you open an issue on issues.powerbi.com please?

fbouckaert
Frequent Visitor

We're migrating from a SSAS Multidimensional on premise to Azure Analysis Services (Tabular),

Composite Model is a very interesting feature for our end users, but I would like to use Calculation Group in our model.

In the Preview the combination of Composite Model and Calculation Group  is mentioned not to be supported.

'Calculation groups on remote sources are not supported, with undefined query results.'

Will it be supported in the (near) future?

Does it make sense to add Calculation Group to our model?

 

Thanks for your interest in the feature, we're still working through a couple of things, this is one of them. However, depending on how you use it this is not going to be supported or might be. In essence, defining a calc group on a remote source is not supported (and I don't think it will soon). However, you will soon be able to define calc groups on your local model.

What do you mean by calculation group on remote source is not supported ?
do you mean in combination with Composite Model ?

 

I defined a Calculation group  in my model, deployed it to Azure Analysis Services and it works fine.
similar when deploying it to on-prem Analysis Services

with remote source I mean a AAS or PowerBI dataset that you connected to using DirectQuery: using a calculation group on such a source is not supported.

I ran som more tests.
Created a calculation group  in the model and deployed it to AAS.

When connecting PowerBI to the model I can use the calculation items in new measures definition.
When adding an excel file as extra source (composite model) the measures in the model using calculation items still work. (YTD PY),

and I can use them in new measures definitions on measures in the model too.
But they cannot be applied to the measures (Budget Value) coming from the excel file.

fbouckaert_0-1619683461024.png

This looks great.
The calculation group defined in the model still works and can be used on measures in the model.
If they don't on the measures from the added source, is acceptable.

Based on this we can continue our developments with the calculation groups.

 

looking forward to the final version of composite model.

Hi,

I am also working with composite model with Direct Query for Power BI Datasets, and with some calculation groups. I was delighted at first to see that this combination seems to work! 😊

 

But althought this works well for me in the desktop, once published to the service I cannot refresh the model, and get this error:

charrington_0-1649872464660.png

I have not added any columns nor calculated table (other than the calc group) to the DQ dataset. So I am thinking I hit the imitation here.

Do you have the same behavior?


It looks pretty close to work, but if we cannot refresh the model, well, it's useless.

 

Thanks

Christian

Helpful resources

Announcements
June 2022 update 768X460.jpg

Check it out!

Click here to read more about the June 2022 updates!

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

Power BI Dev Camp Session 23 768x460.jpg

Check it Out!

Mark your calendars and join us on Thursday, June 30 at 11a PDT for a great session with Ted Pattison!

June 20 episode 7 with aka link 768x460.jpg

The Power BI Community Show

Join us on June 20 at 11 am PDT when Kim Manis shares the latest on Azure Synapse analytics, the Microsoft Intelligent Data Platform, and notable Power BI Updates from Microsoft Build 2022.

Top Solution Authors