Home

Office.js with Excel Online/Power BI

%3CLINGO-SUB%20id%3D%22lingo-sub-733599%22%20slang%3D%22en-US%22%3EOffice.js%20with%20Excel%20Online%2FPower%20BI%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-733599%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20everyone%2C%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EI'm%20new%20to%20all%20this%20and%20I%20have%20a%20question%20about%20what%20can%20be%20achieved%20with%20Office.js%20in%20Excel%20Online%2FPower%20BI.%20I%20hope%20I'm%20in%20the%20right%20place%20-%20if%20I'm%20not%2C%20could%20you%20please%20advise%20me%20where%20else%20to%20ask%2C%20I'm%20going%20round%20in%20circles%20on%20Google.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EAt%20my%20work%2C%20we%20have%20a%20lot%20of%20historical%20Excel%20pivot%20reports%20with%20VBA%20in%20them.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3ENow%2C%20we're%20moving%20over%20to%20Power%20BI%20for%20data%20visualisation%20and%20there's%20a%20question%20about%20how%20to%20retain%20all%20the%20old%20reports%20as%20we%20move%20online%20(since%20Power%20BI%20does%20not%20support%20pivot%20tables%20or%20VBA).%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3ESo%20far%2C%20I%20can%20upload%20the%20Excel%20pivots%20to%20SharePoint%20(Excel%20Online)%20and%20import%20from%20there%20into%20Power%20BI%20-%20that%20way%20I%20display%20the%20pivot%20tables%20within%20Power%20BI%20(keeping%20our%20old%20reports%20and%20new%20reports%20all%20neatly%20in%20one%20place).%20One%20problem%20(pivots)%20solved.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EAs%20for%20the%20VBA%2C%20there%20is%20no%20support%20for%20VBA%20in%20Excel%20Online%20or%20Power%20BI%20-%20but%20I%20read%20that%20Office.js%20would%20be%20a%20good%20alternative.%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3ECan%20we%20use%20Office.js%20for%20the%20same%20tasks%20as%20the%20old%20VBA%20in%20the%20pivot%20tables%3F%20Things%20like%3A%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3E'Refresh%20all%20filters'%20button%20for%20the%20pivot%20tables%3CBR%20%2F%3ECustom%20colouring%20of%20pivot%20fields%3CBR%20%2F%3ECustom%20ordering%20of%20filters%20in%20pivot%20tables%3CBR%20%2F%3ECustom%20ordering%20of%20field%20values%20in%20pivot%20tables%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EI%20need%20to%20assess%20the%20feasibility%20before%20someone%20starts%20having%20to%20learn%20javascript%20to%20replace%20the%20VBA!%3C%2FP%3E%3CP%3E%3CBR%20%2F%3EThanks%20so%20much%20for%20your%20time%2C%3CBR%20%2F%3EStuart%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-733599%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%20for%20web%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
stuart_craig
Frequent Visitor

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,
Stuart

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
35 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies