Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
tessahurr
Employee
Employee

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

531 REPLIES 531
Anonymous
Not applicable

That was the only 1:1 relationship between the 2 datasets in our case, yes. But we did have multiple 1:M relationships in a different composite datasets model, but then no 1:1

Ah.  That seems to be the issue that's 'breaking' it.  Thanks for taking the time to try and help, though, I appreciate it.

Anonymous
Not applicable

Liszet_0-1622635204860.jpeg

This error message shows up quite often when working with composite models connected to 2 datasets in power bi desktop - 'OLE DB or ODBC error. The session ID cannot be found. Either the session does not exist or it has already expired.. Is this to be expected, or is there a workaround? The datasets use a combination of DQ and import (but prominently DQ)

I find if you go to transform data, data source settings, and add another table to the composite data source, it refreshes the session and you can continue working in it (just delete the table you added).  

this is not expected - please open an issue on issues.powerbi.com

Anonymous
Not applicable

I noticed that the following is still a limitation

  • Format strings on columns and measures from a remote source are not imported to the composite model. We are looking for your feedback to prioritize this.

 

When is it expected that this will be fixed? It's quite a dealbreaker for us, since the reports show up with wrong formatting! 

 

I am facing the following scenario:

I am connected to 2 datasets in a composite model. These 2 datasets use direct query both of them. In the composite model I create relationships between tables in the 2 models. One thing I notice is that formatting on measures is gone. F.eks, in dataset a measure is formatted as percentage 3%, whereas in composite model same measure shows 0,03 when used in reports. Or in dataset a measure is formatted as currency with no decimals, and in composite model same measure shows without currency and with decimals. Date columns modify their formatting. Columns that should not summarize, all of a sudden sum. Also, descriptions of measures and columns are not there in the composite model either. 

We are holding off using them for exactly this issue

stay tuned, good news should come soon!

it will be fixed in a future update. I am not at liberty to say here which, but we're shipping it soon and the update will be there before this feature becomes generally available.

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
Advocate IV
Advocate IV

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?

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.