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 t...
Need Help
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.