topic Re: ssas actions in Developer

ssas actions

kvd123 — Fri, 09 Mar 2018 15:58:47 GMT

The document at this link says "Actions and Named Sets are not exposed to Power BI"

https://docs.microsoft.com/en-us/power-bi/desktop-ssas-multidimensional

Then how do you implement detail report using Power BI connected to SSAS multi dimensional model cube?

By detail report, I mean to be able to see what transactions are making up an aggregate number. On Excel connected to ssas, if we select an aggregate number and right click we get an option to run the drillthrough action to see all the transactions from the underlying table that make up that number.

Thanks.

Re: ssas actions

v-chuncz-msft — Wed, 14 Mar 2018 09:46:36 GMT

@kvd123,

You may take a look at Use drillthrough in Power BI Desktop.

Re: ssas actions

kvd123 — Wed, 14 Mar 2018 13:48:03 GMT

Sam, I looked at the drillthrough page at https://docs.microsoft.com/en-us/power-bi/desktop-drillthrough

But I still don't understand whether it is connecting to SSAS to get the drillthrough data or is it connecting to the database engine.

I am hoping to build a solution using Power BI as frontend and connected to SSAS cube database on the backend.
Will this drill through page on Power BI use something similar to SSAS drilthrough action on the frontend, instead of just exposing the SSAS drillthrough action?

Thanks for your response.