Skip to main content
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

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

533 REPLIES 533
Resolver I
Resolver I

Hey maybe this is a bug!


Hey! Maybe this is a bug!


I give access to one user to a report with a dataset connected to two different datasets:


  • One located in the same workspace.
  • One located in another workspace.


When I access into the report with this user:





The report is broken. The details says:





I checked if the user has permission to atleast watch the other datasets, but no! Although I give permission to read the dataset of the report (the one connected to two different datasets) the permissions don’t go automatically to the other datasets and I have to do it manually.

That's normal even for a live connected report. Access doesn't get set across workspaces.

Yes it's true, but now it doesn't work even with datasets that are in the same workspace.

@samaguire is right, you need to give proper (=build for now) permissions to all datasets in the chain.

@jeroenterheerdt  Is it still necessary to give access to the compilation of reports with more than one set of PRO licenses?

sorry, I don't understand the question. Can you please elaborate?

Helper II
Helper II

Maybe this is a known bug? Refreshing two datasets where both datasets have a relationship between tables of the same name in both datasets causes a "Sequence contains more than one matching element" error.

I tried to workaround this (without renaming one of the tables) by setting the data load settings to not load in parallel, but no luck. (Given you can add the datasets individually without issue.)


BTW. discovered this when trying to pull together a report based on the two datasets, no fancy interlinking being done either.


NB: below pic has different table names showing, but underlying dataset has identical naming.




I did find it interesting that this is an issue given the table exclusion rules are being set by lineage tag.



interesting, thanks for reporting.

Thanks for this, I've just started getting the same bug and couldn't work out what it meant - for me it happened when I tried to build a new report on top of the working model, any refresh of the new one hit this error message, while the old one carried on working.  

No problem. That's why I shared. 👍

New Member

While we understand that a developer would require build access to all datasets in the chain, it is unclear to us why a reader would also require build access to all datasets in the chain (why not just read access). To us this is the main reason why we cannot use this -otherwise great- feature at this point as this way we would not be GDPR compliant. Will this change? Or is there perhaps a workaround?

thanks for the feedback - yes, this will change. Readers will just need view permission.

Can you share where this is on the roadmap? Thanks

sure - this is the major blocker for us to declare this feature general available. More news to follow soon on the blog.

Do we have any news regarding not using the construction issue in PRO?

nothing to announce, but we are still working on it and it looks on track.

Hi! This solution also interests us a lot, do we have any news?

this was launched on April 4th: Please note that this is for Premium and PPU for now.

Hi - really pleased when this blog announcement came out.  I had every user who needed access to anything as a Member of the Premium workspace.  I've changed them all to Viewers but now multiple users are only seeing an error on any visualisation from 1 'base' dataset that's part of the composite model.  They can see visualisation from the others datasets that make up the model in the same reports, just not that one.  That report set is published by another user, from a SQL database, to the workspace.  Is this a known exception or should I open a support ticket?Example.jpg


please open a support ticket as this is not supposed to happen.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors