Page 1 of 1

Transform and applied steps in Power Pivot for Excel

Posted: Wed Jan 09, 2019 8:23 am
by atitarev

This is my first post. I am new to Power BI and even "newer" to Power Pivot for Excel
We need to convert some Power BI report to Excel. The source is Analysis Services cube.

I had no issue connecting and doing some work but I can't see the applied steps and "Transform" on the Power Pivot ribbon.

Most importantly, I need to use the pivot/unpivot functions and "append" queries (which is easily available in in Power BI).

I thought it had to do with the type of connection. I have tried connecting to an SQL database and got the same result. If you're familiar with Power BI, then you'll know that in the "Edit query", you can get click on "Advanced Editor" and get the complete "M language" code and I've seen people copying this code into Excel. I can't even get to that functionality in Power Pivot.

My Excel version is MS Office 365 ProPlus.

Your advice will be appreciated.