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
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies