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
Thanks for looking into the issue. Even I am having the same issue. Trying to connect 2 PBI datasets.
In the old reports which had combined PBI datasets, I am unable to establish relationship betweeen tables from different data sets. Seems this issue will get fixed alongwith the earlier reported issue.
I have an OData datsource (InTune Data Warehouse (IDW) ) that I have published to the Power BI Service.
I built a composite PBI Report in PBI Desktop from the above PBI Dataset in the PBI Service that augments the model by joining upns on the IDW model with an organisational data set also joined by upn.
When the new model is published it goes bad. There is a message about the OData source being removed and the dataset cannot be mapped to any datasource.
hmm, interesting. can you please open an issue on issues.powerbi.com or reach out to our support channels so we can collect detailed info from you?
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:
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.
Did you give build access? https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-datasets-azure-analysis-s...
@jeroenterheerdt Is it still necessary to give access to the compilation of reports with more than one set of PRO licenses?
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.
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.
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?
Click here to learn more about the September 2022 updates!
Join us on October 3 at 11 am PST when Amit Chandak, a Power BI Super User, will demo how to use Field Parameters to make reports more dynamic.
Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!