cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
mpaler Frequent Visitor
Frequent Visitor

Export / Import Calculated tables between .pbix files

I have a calculated date table, made in the Modeling section (not query editor) and I'd like to move that calculated table (or some sort of table definitition) to a complete separate PBX file. Is that possible?

2 REPLIES 2
v-ljerr-msft Super Contributor
Super Contributor

Re: Export / Import Calculated tables between .pbix files

Hi @mpaler,

 

How many rows are there in your calculated table?

 

If there are no more than 30,000 rows, then you can try showing all columns from the calculated table on a Table visual on the report first, then using "Export Data" option to export that data to Excel as .csv file.

 

Then you should be able to import that .csv file to the separate pbix file. For more details about how to export data from Power BI visualizations, you can refer to this article.Smiley Happy

 

Regards

mpaler Frequent Visitor
Frequent Visitor

Re: Export / Import Calculated tables between .pbix files

v-ljerr-msft

 

I'm thinking something a bit more flexible/portable -- in the vein of a script that you could run to create the table and columns in one fell swoop. I'm assuming there's no facility for exporting said script -- so, assuming building a table from a script is possible, perhaps someone else out there can share theirs?