Merging RVTools reports using Power BI
RVTools reports are very useful to quickly glance over the state of your virtual environment. However, when you deal with multiple vCenters servers, wouldn’t it be nice to be able to consolidate RVTools reports into a single interface? Enter Power BI. Power BI goes beyond that what you can achieve by using Pivot Tables in Excel. Requirements: Install Power BI Install RVTools What now? Export RVTools reports as Excel files Save the excel files to a dedicated folder Now you have to point Power BI to import sources from a folder. If you want an active representation on how you do this, you can follow this video. Once done, select “combine and transform data” Now, to combine (reads: merge) xlsx […]