Power BI - Bulk import/export Measures

1
votes

Is there any way to import/export measure expressions from excel file in POWER BI?

Its a pain to create all the measures again in every small project.

i know its possible in Qlik sense and other Business Intelligent tools.

1
importpowerbiexportmeasure

1 Answers

0
votes

Yes, this is possible, although not as straight forward as a simple click Export, click Import.

Let me offer up a few options.

  1. Use Excelerator BI's amazing spreadsheet top extract and copy over measures.
  2. Use DAX Studio to copy paste from one to the other (individually)
  3. Use a PowerBI shared dataset. Create your data model in a blank PowerBI. Publish it. Use the published dataset as a source for all your reports/PBIXs that need to depend on a shared model.
  4. If they are simple, move the calculations out of your PowerBI in to upstream ETL processes or aggregations on your database.