Using other Power BI Datasets in Power BI Desktop Query Editor

[GE1]

Hi

Is there a way for a Power BI desktop report to use a table from another Power BI dataset in the Query Editor? I know in the report view, I can go to the 'Data Hub' and select a Power BI model, and access the tables that way. But that only seems to allow me to use those in the reporting end i.e. with DAX measures. But this doesn't seem to be accessible in Query Editor.

What I want to be able to do is access a final, fully-transformed table from one Power BI report (which brings together lots of data sources) in the Query Editor of another report. In that, I would then manipulate it further e.g. by combining it with different data. Is there a way of creating a table in Desktop Query Editor from a table that already exists in another published report?

Thank you

[Idrissshatila]

Hello @GE1 ,

yes, check this https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets

[GE1]

Thanks. But I think I still have the issue.

If I click 'Get Data' from the report page, I can get a published Power BI dataset into the report. (Actually, I believe now you click on 'Power BI Semantic Models', not 'Power Platform'). But if I then click on 'Transform', the dataset isn't there among the tables. It's only available for visualisations, not Power Query. Can I get it in there?

If instead I click 'Transform', go to 'New Source', and choose 'Power Platform' (the only choice with 'power' in it), I have these choices:
- Power BI dataflows (legacy)

- Common Data Service (legacy)
- Dataverse

- Dataflows
None of these contain Power BI datasets or semnatic models. Am I looking in the right place?

[Idrissshatila]

Hello @GE1 ,

no you can't get it to power query because it is a published power bi file, if you want to apply edits on it, then you download it and apply the changes to it because it has it's own power query, you just connect to it to visualise it's data.