Forum Discussion
ssas actions
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.
2 Replies
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.
