Forum Discussion
Export Table definition and Custom Columns to another PBIX
OSC ,
You don't need to copy the dax formulas one by one. You can create a power bi template file(.pbit) and share the template file to your team mate so that your team mate can create another report based on your template.
Please read the blog below:
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hello v-yuta-msft
Thank you for your reply. I followed and read the link provided, somehow informative (I knew some of the info presented there).
However, it doesn't asnwer my question/issue... I am afraid you haven't read my context, or I haven't explained my self well...
I do not want to export everything... I am managing an "official" PBIX and someone else has created ONE table (as part of training/induction), with a lot of calculated columns that eventually we found useful and decided to include inside the official .pbix.
So, I would like to export that table (or 2-3 for that matter, but not all 50+) definition, in order not to rewrite the DAX or copy-paste by hand between the 2 pbix files... Conversly, i might want to give him some additional work, ie 1-2 new tables, withouth resharing the whole file, especially as he might have done its own definitions.
I've also looked inside the pbit as a zip file, reading DataModelSchema as a json, but can't find a straitforward way to locate/isolate that table definition.
So, to summarize, I was looking for Export-Import as with the templates, but for a specific table definition with all its custom fields.
Many thanks,
Cristian
- OSC7 years agoFrequent Visitor
...PS.
or, either like an SQL DDL Script or in PBI, Advanced editor in Query, from where you can copy ALL the defintions steps, columns (added, deleted, modified), so basically you can recreate the structure
Cristian
- OSC7 years agoFrequent Visitor
Nobody...?
Not even at least a reply like "No, you can not do it" ...?
- OSC6 years agoFrequent Visitor
"best" alternative option, so far...
https://community.powerbi.com/t5/Desktop/List-ALL-Calculated-COLUMNS-in-a-Data-Model/td-p/152291