Office.js with Excel Online/Power BI RRS feed

  • Question

  • Hi everyone,

    I'm new to all this and I have a question about what can be achieved with Office.js in Excel Online/Power BI. I hope I'm in the right place - if I'm not, could you please advise me where else to ask, I'm going round in circles on Google.

    At my work, we have a lot of historical Excel pivot reports with VBA in them.

    Now, we're moving over to Power BI for data visualisation and there's a question about how to retain all the old reports as we move online (since Power BI does not support pivot tables or VBA).

    So far, I can upload the Excel pivots to SharePoint (Excel Online) and import from there into Power BI - that way I display the pivot tables within Power BI (keeping our old reports and new reports all neatly in one place). One problem (pivots) solved.

    As for the VBA, there is no support for VBA in Excel Online or Power BI - but I read that Office.js would be a good alternative.

    Can we use Office.js for the same tasks as the old VBA in the pivot tables? Things like:

    'Refresh all filters' button for the pivot tables
    Custom colouring of pivot fields
    Custom ordering of filters in pivot tables
    Custom ordering of field values in pivot tables

    I need to assess the feasibility before someone starts having to learn javascript to replace the VBA!

    Thanks so much for your time,

    Tuesday, July 2, 2019 4:42 AM