Forum Discussion

rabers's avatar
rabers
Regular Visitor
9 years ago

Internal PBI files

hi,

 

i'm new to pbi and i wonder

does pbi has some sort of internal files that holds manipulated data for further reuse?

once i've uploaded data from multiple sources and created a manipulated table based on them. can I reuse that data somewhere alse (other dashboard for example) without redo all the manipulations again?

Need Help

5 Replies

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

    rabers

     

    Analyze in Excel mentioned by BhaveshPatel should be a good choice. Please try it to see if it can meet your requirement.

     

    Best Regards,

    Herbert

    • rabers's avatar
      rabers
      Regular Visitor
      9 years ago

      i probably, didn't explain myself properly...

      i was looking for a some kind of scripting assitance tool.

      non of the above is helping me but i guess that this is due to the nature of this (Power BI) tool.

      i/m comming from Qlikview and i used to do some scripting, data preparation and while doing that - store and reuse Qlikview data files.

      i guess it's diferent in PBI

      • BhaveshPatel's avatar
        BhaveshPatel
        Super User
        9 years ago

        rabers

         

        PowerBI comes with the Advanced Query Editor which is more or less similar to the script editor in Qilkview. It has its own language called M informally and it is predominantly used for the massaging of the data. PowerBI is a two in a one tool consisting of PowerQuery and PowerPivot. The Former uses M as described before and PowerPivot runs on the DAX language, used mainly for the aggregations of the data.

         

        For more information and Demo on the PowerQuery or Advanced Query Editor,

         

        Please see this video in Youtube at here by Matt Allington.