topic Re: Dataflow FROM a shared dataset? in Power Query

Dataflow FROM a shared dataset?

Anonymous — Fri, 30 Jun 2023 11:32:44 GMT

Hi,

I've been shared a dataset and can access the data via direct query in PBI desktop and I've come accross some things which I really need to edit/ move around.

Now whilst I know I cannot view the data or change it unless this is done at source- is there a way to create a flow from the shared dataset in which I can then make the changes I need for my report? Sort of like a secondary dataflow? Or pipeline?

I've never had to do this before so forgive my ignorance if it's a very obvious answer- thanks 🙂

Re: Dataflow FROM a shared dataset?

ppm1 — Fri, 30 Jun 2023 12:37:34 GMT

If your dataset is in a Workspace backed by Premium (or PPU), you can use the approach in this article.

How to IMPORT data from a Power BI dataset - Premium-only - RADACAD

Pat

Re: Dataflow FROM a shared dataset?

Anonymous — Fri, 30 Jun 2023 15:08:55 GMT

This has worked! Thank you so much 🎉