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

463 REPLIES 463
ncmiller
Frequent Visitor

Thanks for the response, I look forward to the fix with the measure table. I'd rather not go back through all my models and switch them over. Question, does that error apply even if the table is a fact table, but all columns are hidden leaving only measures? This looks like a measure table, but still has relationships with other tables. 

 

For the 'Sequence contains more than one matching element' I can get that either when twitching to DQ mode from live-connect, or adding a second DQ model. I've been testing with usage report data models and failed to load a second usage report into the same data model today, though yesterday I was successful. 

@ncmiller @st_oleg @illeke612 @pr2000 @MCornish 

The fix for the error "The given key was not present in the dictionary" when trying to convert a live connect report or add a new DirectQuery AS source that has a measure-only table is fixed in the latest December 2020 build (version 2.88.702.0) which is available in the Download Center and Microsoft Store (might need to manually check for updates). Please let us know if you're still having issues with these data models! 

st_oleg
Frequent Visitor

 

it works.

great fast job! thanks!

ncmiller
Frequent Visitor

Incredible! What a fast turn around. It works like a charm! 

It should only impact measure-only tables (no columns at all). If the columns are just hidden then we don't expect to see this error. 

 

We'll look into the other issue today. I'll reach out if I need more info!

@megank 

Here's the error about "RELATED" formula not working.

1.PNG2.PNG

Thanks for the screenshot, @pamboys09 ! I confirmed with the team that this is by-design. Basically RELATED is not supported for weak/limited relationships, which includes cross-island relationships. This is the same behavior you would see if you were to have a composite model with two SQL DirectQuery sources (because they're in different islands), you can do this for import tables because they're all in the same (local) island.

 

You can find more info about this on the RELATED function docs here: RELATED function (DAX) - DAX | Microsoft Docs and the section on Limited relationships her: Model relationships in Power BI Desktop - Power BI | Microsoft Docs

mim
Advocate V
Advocate V

first feedback so far.

1- it will be nice to have description from the source model supported thinking of using it as a way to document the measure formula, so downstream users can see the formula used in a measure.

2-is it possible to deleted tables and measures, in some cases, all I want is getting data using directQuery from 1 Table.

3- if 2 is not possible, can we have a folder to group all the tables and measures from 1 model, otherwise it may become very hard to navigate big models.

 

very great works

Hi Mim, for 1: we have for now decided not too, since there might be intellectual property in the model or other reasons not to expose the definition. Regarding 2: not sure what you mean here.

Anonymous
Not applicable

Very excited for this!  However, we create our data models in SSAS, so the only way we can leverage this is to connect to SSAS, publish the model to Power BI Service, then connect a new *.pbix to it.
Does that cause a degredation of performance to essentially use the Service as a passthrough to SSAS?

Hi I tried that. You do not get the option to switch to direct query mode although the get data button is not disabled.. I think Power BI knows that SQl Server Analysis Services is behind the dataset. If you can get that to work though it would be helpful.

I don't think that would be a great solution, too many hops and you are really trying to make something work that is not supported.

drewlarson
Frequent Visitor

This feature could be incredibly powerful. I have a core dataset that requires slight enrichment by each customer... which currently would result in many datasets. I'm excited at the possibility of reusing the core dataset and then enriching it. 

 

One issue I noticed right away is that it doesn't seem like date heirachy from the Power BI dataset i'm connecting to is supported. Any chance that can get fixed? 

not sure what you mean, can you give us some more details?


@drewlarson wrote:

One issue I noticed right away is that it doesn't seem like date heirachy from the Power BI dataset i'm connecting to is supported. Any chance that can get fixed? 


@drewlarson I think the limitation with date hierarchies was addressed in the blog post....

 

You may see some unexpected behavior when using a date hierarchy. To resolve this issue, use a date column instead. After adding a date hierarchy to a visual, you can switch to a date column by clicking on the down arrow in the field name and clicking on the name of that field instead of using “Date Hierarchy”:

This behavior will be addressed later in the preview.
For more information on using date columns versus date hierarchies, visit this article.

WillHopkins
Frequent Visitor

Very disappointed SQL Svr Analysis Services is not yet support. Can you clarify what release of SQL Svr will be needed and when we can expect it?

We are looking at the next major release of SQL Server. The feature name is "...Azure Analysis Services" on purpose 🙂

Thanks that is helpful information. We will keep and eye out for the feature. 

ggaudfroy
Advocate I
Advocate I

C'est la nouveauté de 2020!

Joli cadeau de Noel!!

psolli
Advocate II
Advocate II

@tessahurr We are currently building models and testing it. So far it looks fantastic. This is the new Holy Grail of Business Intelligence. Power ON will report back with all findings shortly.  We will be making some very exciting anouncements soon for the Power BI Community as well. Just need to make sure it is all there.

Must be a very excting day for the Product Team. Congratulations!

 

Per

sam_xlpowerbi
Frequent Visitor

Game changer - however the performace is quite poor even on small data sets (30 K) rows

 

Cheer Sam

Helpful resources

Announcements
August 2022 update 768x460.jpg

Check it Out!

Click here to learn more about the August 2022 updates!

August 1 episode 9_no_dates 768x460.jpg

The Power BI Community Show

Watch the playback when Priya Sathy and Charles Webb discuss Datamarts! Kelly also shares Power BI Community 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.

Top Solution Authors
Top Kudoed Authors