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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
tessahurr
Microsoft Employee
Microsoft 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

534 REPLIES 534
ManuGP
Helper I
Helper I

Hi! We have been using this feature for almost 2 years. There is one limitation that I see that no one commented on. 

I am now used to "Limited relationships" when connecting tables in DQ mode from different sources, or even btw imported and DQ tables. But when we have tables in different datasets in the same workspace I would have expected this to be considered the same source. 

Would be nice to have a single Power BI workspace considered as the same island and thus any 1:* and 1:1 relationships be considered "regular".

 

Our use case is that we have many datasets and the idea was to let some self service users with Power BI desktop knowledge to "mix and match" to build their own datamodel without needing to import any data as everything is already available in the same workspace. The limited relationship concept is a little bit tricky and harder to take into account for end users (specially since there is almost no warning in Power BI dekstop about what this entails). Some use cases (requiring regular relationship) that are easy to achieve with data imported in the same dataset cannot be done when using data that is already imported in the workspace BUT in different datasets.

 

 

Hi @ManuGP - thanks for the feedback. However, this is not how this is designed. Even if items are in the same workspace they are not going to be considered as one source group: a source group is tied to the source (each DQ source is a source group), with the exception of all Imported sources being the same source group.

The thing is: If I have different Power queries in DQ to the same system (even in separate schemas in databricks for example) they are considered by Power BI as in the same source group and the relationships between them are regular. I don't know what is the technical restriction but I would expect the same when connecting in DQ to different datasets in the same PBI workspace.

 

The current behavior pushes me towards thinking I should put all the tables in the (in 30+) datasets into one enormous dataset, but I'm sure that will have many drawbacks.

Or is there another setup that would work better for this use case? Any thoughts are welcome.

It's just a design choice from our side, given that we manage the Power BI dataset for you.

Then that's my feedback: if relationships across datasets were regular (by considering one PBI workspace as a single source group) it would make this preview feature much more powerful.

Thanks!

thanks for the feedback - I will discuss this internally, but I don't think this is going to change soon.

Anonymous
Not applicable

This is an excellent feature that is very useful for us. But We are not able to change the existing power bi Datasets in Service to Composite model. We need to create a new dataset everytime? We have many reports that are embedded in our site and dont want any impact on the Report ID's

this feature is built to allow you to extend / enrich existing datasets. That would turn them into a composite. Not sure why you would want an existing dataset into a composite if you are not changing / extending it. If you added extension / enrichment you will be creating a new dataset and can leverage an API to "rewire" your reports if you were so inclined. https://learn.microsoft.com/en-us/rest/api/power-bi/datasets/update-datasources

Anonymous
Not applicable

Not sure if i explained it right. I have a existing dataset for which i would add a calculated table. after adding calculated table, when i publish the data set it is publishing as a new dataset and not overwriting the already available dataset even though the names are same. if this is expected behaviour, rewiring the reports will make the report id change?

Hi @Anonymous, we work with PBI datasets on a daily basis, updating and expanding upon them: for instance by adding a calculated table to an existing PBI dataset. This way of working is also called the 'Golden Dataset' principle, and will not change IDs of dataset or linked reports.


If you are working in the original file (.pbix) of the dataset, and publish this accordingly, the expected behaviour is that the dataset in the PBI Service will be updated (you will also see a warning in PBI Desktop when publishing notifying you of this). 

 

If the above does not help, could you provide more information on the steps you are actually performing when extending upon an existing dataset?

Anonymous
Not applicable

@FraukjeC 

 

https://community.powerbi.com/t5/Issues/Unable-to-Change-power-bi-data-set-from-live-to-composite-mo...

 

I have already posted a thread with the issue i am facing. Hope this explains my scenario more. 

 

Please let me know if you find a solution to the above mentioned problem 

I responded to the link above - basically it's what I said: this feature allows you to extend / enrich a dataset and publish it as a new artefact. It's not the intent of this feature to overwrite the existing dataset.

FraukjeC
Frequent Visitor

For us, this feature is very promising and we have taken steps to implement it within our enterprise (5000+ employees with Pro licenses). However, we ran into the limitation that all Viewers of reports that are developed using this feature must have Build permissions on all underlying datasets, and this is very troubling for us. Giving out Build permissions to employees who only (based on their function, and/or data-literacy level) require to view reports poses a high risk for us. 

 

Currently we are urgently looking for a work-around or alternative solution to offer Customizable managed self-service BI to employees with Power BI within our the enterprise, as advocated in this Microsoft blog. Is there any update on the limitation that Build rights are always needed with the "DirectQuery for Power BI datasets and Azure Analysis Services" feature?

This is the way it used to be for us, but they did change it to only require viewer permission a little while ago.  Maybe this is only for premium licensing?  we have premium.  But we don't have to add them as a build access anymore to view a report that is using direct query for power bi dataset.  Now, if they want to analyze in excel and build off the dataset, then they need build access.

Hello @FraukjeC , thanks for checking in! @mamsteroonie is right, we changed the required permissions for Premium/PPU to just require Read permissions for viewing a report. Right now for Pro you still need Build. We are working on aligning that to Premium/PPU but it is taking longer than expected. 

Hi @jeroenterheerdt and @mamsteroonie, thank you both for your information! We are indeed aware that within Premium/PPU licencing this issue is resolved. However, we have invested majorly in taking our full organisation to the next data-driven level by providing Power BI Pro licenses for all (5000+) employees only one year ago, so for us currenlty moving on to Premium/PPU licencing is not an option. 

 

@jeroenterheerdt I feel very optimistic hearing that Microsoft are actively working on removing the Build limitation for Pro users. This could mean that simply 'wait and work with the current limitation' might be a valid option for right now. Could you provide any time of timepath for this limitation to be fully dealt with for Pro users? Could we expect this within the current calendar year (2023) perhaps?

Unfortunately I cannot say any such thing in this public forum, but we are working on a blog post that should shed some light on what you're asking. (By the way, congrats on the 500th message in this thread!)

It has come to our attention that this issue has been solved! I have not found any official Microsoft communication regarding this, but we discovered it ourselves and found a blog post by A Guy In A Cube comfirming this (start at 5:23): 
https://youtu.be/CIIzUvoUMOc?t=322

 

@jeroenterheerdt Would you happen to know if there is any documentation/release notes available somewhere on this?

this has indeed not been resolved for all workspaces / customers. We are still working on it. We expect more news in April.

florenti
Regular Visitor

I made a connexion with DirectQuery for Power BI datasets.

It's fantastic, very useful and powerful.

But, and it's a big BUT, once the connexion is made, there is no way to remove it!

Please, could you solve that ?

Hi @florenti thank you very much for you feedback and for trying this out! I am glad you like it! Regarding your question, I assume you have been looking to find the connection in the Power Query / Data Transformation window. It is by design that you will not find the connection there - as written in our documentation. However, you will be able to delete the connection using the Data Source connection dialog (Transform Data --> Data Source settings), in which you can also update the connection info if required.

Please let me know if this helps or if you are seeing anything else.

Helpful resources

Announcements
September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.