Forum Discussion
Using other Power BI Datasets in Power BI Desktop Query Editor
Hello Anonymous ,
yes, check this https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-report-lifecycle-datasets
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?
Hello Anonymous ,
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.