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
Leodie3
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: https://powerbi.microsoft.com/en-us/blog/update-to-required-permissions-when-using-composite-models-.... 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.

Good afternoon! How cool, our licensing here at the company is PRO, do you imagine that the resolution of the technical problems reported to enable the solution for PRO should be resolved soon?

"soon" is a relative term and I cannot give any timelines. However, we are working on it.

How can I be notified when this is done?

monitor the blog (blog.powerbi.com) or social media 🙂

garddolau
Frequent Visitor

Hi Team,

 

Getting the below message while trying to link 2 tables in one dataset to a date dimension held in another dataset.  Any plans to allow this behavour? or how would you suggest completing what would be a common scenario for us?

 

Thanks

 

island_error.jpg

 

No, this will not be supported. Either split your dataset your trying to relate into two or bring the hared dimension (DimDate) into both and leverage synced slicers. Also, I'd recommend watching SQLBI's video on this preview feature as well

Do you have a link to this video?

JoshAsh
Frequent Visitor

Are there any plans for support for calculation groups where a query is running in retail mode and the calculation group is defined on the remote model?

 

https://www.sqlbi.com/articles/understanding-the-interactions-between-composite-models-and-calculati...

 

Almost all enterprise models will contain a calculation group for Time Intelligence that users are well accustomed to using. Alternatively would it be possible to show an error rather than an incorrect value where the measure contains both wholesale and retail execution and will therefore show unexpected results?

In that way the use of the calculation group won't return incorrect results. 

 

no plans, as SQLBI explains in the link you posted it might not even be possible, at least not with major investment.

FK3
Frequent Visitor

Today I had a user who's getting this error from reports created using composite models.
"COM erros: Microsoft.PowerBI.AS.ConnectionDetailsProvider. Missing connection string password"
Cloud credentials for these datasets are working. We're going to submit a ticket, but posting here in case others are seeing the same thing or if there's a quick fix. 

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