Forum Discussion
Help: Weekly Report - OLAP Cube refresh use dynamic slicers, export to xlsx file to add comments
I have an xlsx workbook with a OLAP Cube Query that gets refreshed weekly in a manual process. I need to reinvent this to be cloud based and automated. Need guidance on architecture to get this w...
From Excel you can connect directly to the semantic model and run DAX queries. Not so sure about MDX but most likely possible as well.
If the excel file is sitting on sharepoint, can I use Powe Automate to refresh DAX Queries? Would that be using Power Apps for the query and Power Automate to call on it?
I tried Office Scripting but that does not support data queries like this one.
Thanks!
no need for PowerApps.
Office Scripts can refresh all connections in an Excel file...