Import query , functions defintion from one pbix to another.

[ozmike]

Hi

If I have one query or function can i import the definition into another pbix , for example in MSaccess you can import queries.

This is to prevent me having to rebuild it from scratch , i  have been able to cut and paste from the advanced editor - but there must be a way to import multiple objects..?

[MalS]

You can go to File > Export > Power BI Template.

Then, in your other file, go to Import > Power BI Template and select the file you just created.

[ozmike]

Seems to import the all definitions , i  want to import select  some queries (as in msaccess) as the file i want to import from has about 20 queries I only want a couple  , does the method you describe import /export the whole file ?

[MalS]

Yes - this is the whole file.

As far as I know there is no way to select which queries you want to import - it's all, or nothing.

Still, it's relatively quick to import them all and then delete the ones you don't want.

[ImkeF · Accepted solution]

You can just select them in the queries-pane and copy them: https://blog.crossjoin.co.uk/2017/02/25/exporting-your-queries-m-code-from-power-query-and-power-bi-...

Cool thing: This also works between Excel and PBI in both ways.

& You can also select folders (so no need to select single files then).

Another cool thing: If you paste them to a text-editor instead, you get all the query code 🙂

[ozmike]

Too Easy - cut and Paste - must be new technology!

[MalS]

Nice trick - I hadn't thought to try that between pbix files!