Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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..?
Solved! Go to 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 🙂
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
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.
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 ?
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.
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 🙂
Imke Feldmann (The BIccountant)
If you liked my solution, please give it a thumbs up. And if I did answer your question, please mark this post as a solution. Thanks!
How to integrate M-code into your solution -- How to get your questions answered quickly -- How to provide sample data -- Check out more PBI- learning resources here -- Performance Tipps for M-queries
Too Easy - cut and Paste - must be new technology!
Nice trick - I hadn't thought to try that between pbix files!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
99 | |
80 | |
64 | |
57 |
User | Count |
---|---|
145 | |
111 | |
92 | |
84 | |
66 |