Forum Discussion
Drill through cross reports
Hello,
I have a double question. I'm wondering if it is possible in Power Bi, the following scenaro is possible !
Drill Through between 2 pages of the
1- Create a report based an SSAS cube on one page and a detailed report from the same DW but based on SQL server
or
2- Create 2 differenr reports, one based on SSAS cube (whatever if it's an OLAP or TABULAR cube) and another totally different report based on SQL Server and the perform a Drill Through from the SSAS report to the SQL server report.
Thanks in advance for any answer.
Hi @REP85 ,
answer to question (1)
at the present time, this is not supported due to the fact that real-time connections (SSAS Tabular (on-premises or in Azure) or SSAS multidimensional are not supported in composite models. MSFT has already announced support for Power BI and Azure Analysis Services data models in composite models, then this will be possible. Here's the link to the current Power BI roadmap: https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/business-intelligence/composite-models-over-power-bi-azure-analysis-services-datasetsHowever, I have no idea if local Tabular SSAS will be supported as the feature evolves. I doubt that SSAS Multidimensional is supported at all.
answer to question (2)
perhaps you can adapt the solution described in this article by @paul_turley: https://sqlserverbi.blog/2019/07/04/drillthrough-from-power-bi-to-an-ssrs-paginated-report/
@REP85 , It is about linking SSAS Tabluar, Not sure to adapt to your requirements https://docs.microsoft.com/en-us/power-bi/desktop-analysis-services-tabular-data. I think for other things @TomMartens has already given the answer
4 Replies
- TomMartens
Super User
Hi @REP85 ,
answer to question (1)
at the present time, this is not supported due to the fact that real-time connections (SSAS Tabular (on-premises or in Azure) or SSAS multidimensional are not supported in composite models. MSFT has already announced support for Power BI and Azure Analysis Services data models in composite models, then this will be possible. Here's the link to the current Power BI roadmap: https://docs.microsoft.com/en-us/power-platform-release-plan/2020wave1/business-intelligence/composite-models-over-power-bi-azure-analysis-services-datasetsHowever, I have no idea if local Tabular SSAS will be supported as the feature evolves. I doubt that SSAS Multidimensional is supported at all.
answer to question (2)
perhaps you can adapt the solution described in this article by @paul_turley: https://sqlserverbi.blog/2019/07/04/drillthrough-from-power-bi-to-an-ssrs-paginated-report/
- amitchandak
@REP85 , It is about linking SSAS Tabluar, Not sure to adapt to your requirements https://docs.microsoft.com/en-us/power-bi/desktop-analysis-services-tabular-data. I think for other things @TomMartens has already given the answer
Hi Amitchandak
Many thanks for your reply, I'm going to look at the article
BR
Hi Tom,
Many thanks for your quick reply. The solution looks great. We are goint to test it rapidely.
BR
