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:
Thanks and we look forward to hearing your feedback!
- The Power BI Modeling Team
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
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?
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.
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.
Relatedly, I have also been getting silent failures to generate a code for a public embed. After I click publish, I get a spinner for half a second, then it disappears and no error message comes up.
This is working with all other reports that don't have Direct Query connections to other Power BI datasets. The project was to create an external-facing dashboard that compiles data from a number of sources, so it's important to embed this way (in a SharePoint page).
We are also eagerly awaiting support for Power BI Embedded - this is a huge blocker for us. Any idea on a timeline for availability?
"Select tables" in live connection not working. Every time when I select a dataset all the tables get loaded in and I don't see the pop-up window.
I have the November version and I have activated the preview for DirectQuery for Power BI datasets and AAS.
Is this something that I'm only facing?
If you connect to a dataset and bring in selected tables, is there a way to get another table? Let's say you originally select 7 tables and then you realize you need an 8th one, can you bring in that table as part of the same model, or can you only bring it in by chaining a copy of that dataset?
Hi @Anonymous yes and yes 🙂 But we're dependent on the release of SQL Server for the support of SSAS. The other one is currently being investigated.
Hey! This is a very nice functionality!
Let me ask you one question:
Is it possible to connect to Power BI datasets that are published from Microsoft Excel?
It try it, but when I select the dataset, the options of connect to another dataset disappear.
I have received error "Sequence contains no elements", when refreshing the Power BI datasets in composite model. This did never happen with May version of desktop but occurred after upgrading to October and again to latest version published about a week ago.
Sequence contains no elements
at System.Linq.Enumerable.Single[TSource](IEnumerable`1 source) etc.
Now this error message doesn't appear anymore but instead everytime I open the file, I get a new error 'Error getting value from 'CanDelete' on 'Microsoft.PowerBI.modeling.Engine.DataModel.Table' Error getting value from 'CanDelete' on 'Microsoft... - Microsoft Power BI Community
I am getting an error "An error occurred while loading the model. Verify that the connection information is correct and that you have permissions to access the data source." while trying to activate model editor with "Make changes to this model" to Push Dataset in Power BI Service.