Forum Discussion
Internal PBI files
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
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
- BhaveshPatel9 years agoSuper User
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.
- smelei9 years agoAdvocate I
Would doing a Save As on the original dashboard and then deleting the pages and starting afresh on the new dashboard visuals meet your needs?
Not sure it would capture everything you need, but copying everything from the Advanced Editor (Edit Queries > View > Advanced Editor) and then pasting into a new dashboard might also give you what you're after (though if you've got a lot of queries, it might be time consuming).
Hope this helps!