Forum Discussion

mpaler's avatar
mpaler
Frequent Visitor
9 years ago

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

  • v-ljerr-msft's avatar
    v-ljerr-msft
    Microsoft Employee
    9 years ago

    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.:smileyhappy:

     

    Regards

    • mpaler's avatar
      mpaler
      Frequent Visitor
      9 years ago

      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?